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 |
|
nbpatil
Starting Member
14 Posts |
 Posted - 2004-10-26 : 23:21:48
|
| Hi..I am using SQL Server 2000 and want to setup Transactional Replication between 2 servers.For the same i want to avoid copying bulk data using Initial Snapshot.For various reasons SnapShopt Bulk Copy stops in between.1)Instead i have plan to restore DB1 to remote server.Then want to start Transactional Replication.2)If i do so, What abt validation of data.?Will it validate each and every table rows before replicating the transactions taken place at Location1.What exactly sql server do when i set Transactional Replication between 2 simillar SQL databases.In any case i want to avoid Initial Snapshot Copying process which breaks my Transactional Replication Process.Thanks & RegardsNitin Patil |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-27 : 02:22:14
|
quote:
Originally posted by nbpatil
Hi..I am using SQL Server 2000 and want to setup Transactional Replication between 2 servers.For the same i want to avoid copying bulk data using Initial Snapshot.For various reasons SnapShopt Bulk Copy stops in between.1)Instead i have plan to restore DB1 to remote server.Then want to start Transactional Replication.2)If i do so, What abt validation of data.?Will it validate each and every table rows before replicating the transactions taken place at Location1.What exactly sql server do when i set Transactional Replication between 2 simillar SQL databases.In any case i want to avoid Initial Snapshot Copying process which breaks my Transactional Replication Process.Thanks & RegardsNitin Patil
you can set up transactional replication by:1. choosing that schema and data are already in the target database2. then after the replication have been set up, edit the articles, choosing just to delete all data in the table instead of dropping the table.you can't avoid snapshot process because if ever there were any conflicts in data or validations, sql needs to resolve this. but try the suggestion above first...--------------------keeping it simple... |
 |
|
|
|
|
|
Transactional Replication-Want easier way.!