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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 regarding replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-08 : 09:31:01
kanya writes "I am using merge replication for replicating the tables between the servers.but frequently i facing the problem because the data transfer is more. Sometimes i getting the error 1.'The process does not query the row metadata of publisher' and tables are not getting replicated.
2. Even if the replication is working, one or two tables are not replicating in the other server.
Could please suggest other alternative other than replication."

DavidD
Yak Posting Veteran

73 Posts

Posted - 2002-05-09 : 21:02:49
Script the data transfer yourself using distributed transactions. Your T-SQL will have to be fairly handy, but it is a way better method than the out of the box SQL method which has many limitations.

Regards
DD

Go to Top of Page
   

- Advertisement -