SQL Compare versus sql server replication

dlaub1dlaub1 Posts: 2
edited July 8, 2010 11:01AM in SQL Compare Previous Versions
Can anyone comment on the pros & cons of using SQL compare vs. sql server replication for schema (not data) replication

Thanks
· Share on Twitter

Comments

  • Chris AucklandChris Auckland Posts: 769
    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
    · Share on Twitter
Sign In or Register to comment.