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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-09 : 09:33:54
|
| Gagan writes "HiWe did a full backup of a DB on Server A (SQL Server 2000) and restored it on Server B (SQL server 2005). Since we have Notification Services, so we run nscontrol upgrade command to upgrade it to 2005. We want to test our application by pointing test server to Server B, while our live application is running by still pointing to Server A.Now we want to make the states of Server A and B in sync. What can be the best approach for this, since during upgrade some data gets modified. Will differential backup work in this scenario? replication does not work due to some reasons.Please help us, as it is blocking our deployment.Thanks,Gagan" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-09 : 15:11:05
|
| you could use a tool like SQL Data compare from red-gate to sync up your servers. This might be a bit of a ping depending on the complexity of your schema.apexsql also has a similar data sync tool if you want to feature compare.-ec |
 |
|
|
|
|
|
How to sync the states of 2 database servers