Using Sql Compare with Replication?

glenhongglenhong Posts: 2
edited May 30, 2006 9:58AM in SQL Compare Previous Versions
Hi,

We are looking for a tool such as sql compare to synchronise databases. We are pretty sure that it has everything we need. However, we are not sure if it works on a replicated database.

Does anyone know if you can synchronise with a replicated database?

Thanks in advance

Glen Hong

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Glen,

    SQL Compare isn't replication aware, so for instance if you have a column involved in replication, you cannot simply DROP it like SQL Compare wants to do, you'd need to run a special stored procedure called sp_dropreplcolumn. This means that if SQL Compare needed to drop a column that is involved in replication, SQL Compare's script could fail.

    Detecting and handling replication is something we are looking at doing possibly later on.
This discussion has been closed.