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.
dlaub1
Posts: 2
Comments
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.