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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-06-20 : 13:19:56
|
| Hi,I need to refresh Dev database from Prod. On Dev db developers created some new tables. They don't want to overwrite their tables when db refreshed from prod. In prod right now these tables are not there and not required.My question is how to refresh dev db from prod so that only tables in prod should be updated/replaced in dev while keeping other tables as is.Any help will be appreciated.Thanks |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2012-06-20 : 13:49:34
|
| You may just want to keep the copy of your dev db (rename the dev db), then restore the prod db, then just copy the "new" tables over from your dev db to the db you just restored from prod.Donn Policarpio |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-06-20 : 15:28:41
|
| Thanks for reply.Different teams are working on this db. I don't know which tables related to them. There are large numbers of tables in this db. Anyhow I talked to developers and I will restore prod db with new name in dev. Then they can use new db. |
|
|
|
|
|
|
Refresh database