|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Update copied DB
I need to refresh a test db from the production DB but need to save some
tables in the test db.. Is there a way to do this ? without using a third part app ? rename database you are restoring too. restore prod copy. use
import/export wizard to move data from renamed db to restored db. -- Show quoteHide quoteKevin G. Boles TheSQLGuru Indicium Resources, Inc. "Stup88" <Stu***@discussions.microsoft.com> wrote in message news:94C7966A-15E6-40AA-95E5-0DEF28C361EF@microsoft.com... >I need to refresh a test db from the production DB but need to save some > tables in the test db.. > > Is there a way to do this ? without using a third part app ?  |
|||||||||||||||||||||||
Other interesting topics