Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Kassey Truesdale  
#1 Posted : Wednesday, July 1, 2009 9:33:58 PM(UTC)
Kassey Truesdale
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Perth, Western Australia

A large job we have been working on for a few years has been given a new job number. Our task now is to figure out the easiest way to make sure the data stays together). I was wondering-instead of moving all the data from the original job number into the new one, or depositing any new data into the old job number-is there a way to change the job number to the new number? without a large data move?
Warwick Wood  
#2 Posted : Wednesday, July 1, 2009 11:11:12 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 506
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Yes there is:

I understand you are using the SQL Server version.  All your data will have an existing Site ID and Project ID.  You can import your new data to the same Site ID but use the new Project ID. 

If you want to ensure no new data is imported to the old Project ID you can set the 'Active' status to off.  The 'Active' status is in the Project table and can only be changed by a user with DBO permissions.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.