How can we help you today? How can we help you today?

Using Sql Compare with Replication?

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
glenhong
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.