Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
MichelleMA
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? |
|
X002548
Not Just a Number
15586 Posts |
|
MichelleMA
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. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-05 : 00:33:48
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Script+Development+Database+Changes+to+Production+DatabaseKristen |
|
|
|
|
|