| Author |
Topic  |
|
|
MichelleMA
Starting Member
USA
32 Posts |
Posted - 12/04/2006 : 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
USA
32 Posts |
Posted - 12/04/2006 : 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
United Kingdom
22191 Posts |
|
| |
Topic  |
|