Activity overview
Latest activity by Chris Darts
Thanks for the quick reply Richard.
I'm glad this has been brought to my attention now I'm still using the evaluation version before purchasing the full copy, as on your products page it certainly makes it seem like it works fine with replication, not just comparing but for synchronizing databases: "One other functionality of SQL Data Compare is the ability to synch the databases so, if a replication has failed, work can continue while issues are addressed." http://www.red-gate.com/products/SQL_Da ... simple.htm
Thanks,
Chris / comments
Thanks for the quick reply Richard.
I'm glad this has been brought to my attention now I'm still using the evaluation version before purchasing the full copy, as on your products page it certainly ...
I'm pretty sure it won't work unless I can insert in the primary key field as the foreign keys will almost certainly be incorrect. Is there no way to drop the replication constraint on the PK before inserting the rows?
Can I just check that SQL Data Compare is designed to work with SQL Server 2005 Replication?
I saw this post the other day and it got me wondering (although it's posted for a previous version of the software): http://www.red-gate.com/messageboard/vi ... t=2532#top
Thanks again,
Chris / comments
I'm pretty sure it won't work unless I can insert in the primary key field as the foreign keys will almost certainly be incorrect. Is there no way to drop the replication constraint on the PK befor...
Problem synchronizing data using merge replication
One of my subscribers has stopped replicating with the publisher in SQL Server 2005 so I am trying to append any new rows created at the subscriber to the publisher using SQL Data Compare.
The comp...