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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-04-06 : 06:49:41
|
| Dear All,I am new to database administration.In our current company i was told by that t synchronize data between 2 servers.For that the user Don't want to take backup from Server A and to restore it in Server B.I ran the regular load process to sync data between these 2 however still i am seeing the data difference.Can you guys please help to identify how to resolve this issue.I need to make data sync for 4 tables in terms of data and schema.I worked with evaluation version of Redgate data sync software as it was evaulation version i can't use it for production server.Thanks,Gangadhara |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-04-06 : 13:55:08
|
| Have you looked into replication?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-04-07 : 00:24:57
|
| See i just want to make one time sata sync remaining will be taken care by dially load process i need to sync for there data between 2 servers |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-04-07 : 00:49:24
|
| Use the data import export wizard. If you have a large database you might want to backup and restore.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Data Sync between 2 servers