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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-03-21 : 10:58:46
|
| Best Practice:I have a DB in a test environment that DB is also copied onto a production (BETA) server. What is the best way to update the production box with the changes made in the testing area without messing up the data that is on the prod server. Right now I am using some DTS to move procedures, triggers etc and data. It is a pain and I don't think I am doing it right.Any suggestions or help would be appreciated.By the way thanks for all of the previous help with solutions and questions answered . I typically don't repost a thank you reply as to not create more posts and or hits. You guys are awesome but, What is the practice for this?slow down to move faster... |
|
|
Jay99
468 Posts |
Posted - 2002-03-21 : 11:29:12
|
| Change control is a tricky business . . .There are some suggestions here.You will need to come up with a process that works for your situation. Usually this will include a roll script, or at least a list of changed objects (and the ddl when necessary) . . .Jay<O> |
 |
|
|
skillile
Posting Yak Master
208 Posts |
Posted - 2002-03-21 : 17:10:54
|
| Thanks,OK along the same lines is there an easy my to rename the MDF and LDF of the DBie db_data.mdf db_log.ldfto db1_data.mdf db1_log.mdfI figured out how to rname the DB but not the actual files.Thanksslow down to move faster... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-21 : 17:13:13
|
| You'll need to detach the database (using sp_detach_db), rename the file(s), then attach the database files (sp_attach_db). |
|
|
|
|
|
|
Database Modifications