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

SQL Compare versus sql server replication

Can anyone comment on the pros & cons of using SQL compare vs. sql server replication for schema (not data) replication

Thanks
dlaub1
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    SQL Compare isn't really a replication technology or a replacement for replication, but if you want to use it just to make a copy of certain database objects I would say that the main advantage of using SQL Compare over SQL Server replication is that you can quite easily get some feedback (using the GUI, or outputting a report) that the replication is successful.

    SQL Compare is also much easier to configure, but you will need to schedule it using another process such as a Windows Scheduled task. Unless you want to use xp_cmdshell.

    I hope this helps.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.