Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Moving Changes from Developement to Production

Author  Topic 

Starting Member

32 Posts

Posted - 2006-12-04 : 14:50:44
To move the new developed modules from Developement to Production, I have to clean the dev tables (and relashionships) , import the data from the production tables, replace relashionships, then copy the db files from Developement to production.
Is this a correct way to do it? is there a better way?

Not Just a Number

15586 Posts

Posted - 2006-12-04 : 15:20:07
Why don't you just create a sql script of the changes and apply them to production



Hint: Want your questions answered fast? Follow the direction in this link

Add yourself!

Go to Top of Page

Starting Member

32 Posts

Posted - 2006-12-04 : 20:08:16
Thanks Brett,
since I have many creates and updates to SPs/Triggers/tables/relashionships and the archive DB, I was kind of afraid to skip logging a change in the SQL script, but I guess updating using the script is better than deleting all relationships and data, importing then replacing, ...copying again.
Thanks for your reply.
Go to Top of Page


22859 Posts

Posted - 2006-12-05 : 00:33:48

Go to Top of Page

- Advertisement -