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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-04 : 08:09:17
|
| vijay writes "How can we replicate database changes (like tables) from QA environment to Production without losing the destination data.Already tried the dts export but it drops the destination tables before export." |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-04 : 08:11:44
|
| There's no 'magic wand' for this, you'll have to identify the changes on an object by object basis and use T-SQL commands such as ALTER TABLE to port your development schema into your production schema.Raymond |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-04 : 12:27:02
|
| Don't replicate table changes! That is so bad. You should already have scripts that were used to build the QA environment from development environment. Use those scripts to update production. If you don't use scripts, you need to start doing it as that is the only safe way to get things done right.Tara |
|
|
|
|
|
|
Porting Database Changes from QA to Production without data loss