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 |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2007-12-31 : 12:22:26
|
| I have two databases in my development desktop which is tied up using transactional replication. I want to test my application on a Development server. Which I guess is very much similar to the production server.Will the replicated databases work fine if I just move them to the development server or shall I move the databases to the the target server and do the replication procedure again.Please advice. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-12-31 : 13:01:16
|
| You can do it in a couple of ways. You can get the latest backup from prod server and restore the same copy onto both your dev servers and then setup replication with no initialization. Or, restore the prod copy onto one of the dev servers and initialize. I recommend the first method.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
replication