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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2009-07-10 : 06:14:48
|
| Hi WE are using testing server db. sometimes we need to have the production dats in the testing server.meaning we have to import the data to testing server.is there any way we can sync the prod data to testing server.Please do the needful. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-10 : 07:00:30
|
Maintain a script or something with all your changes to DDL.When it is needed take a backup from production and restore it to the testing server.Then run your script to get the database up to your currently needed version.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2009-07-10 : 07:53:46
|
| I need only the data, i dont wanna any scripts only data has to be imported from all the tables.Production data has to be dumped into testing server. |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2009-07-19 : 20:30:46
|
If it's all located on a SAN, most SANS come with a "snapshot" tool to do this... very quickly I may add.--Jeff Moden
"Your lack of planning DOES constitute an emergency on my part... SO PLAN BETTER! ""RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row" |
|
|
|
|
|
|
Data Sync