How can I execute a sdc file as a sql agent job on a sql server?

BenKim

I want to automate comparing data between two servers daily, and get a report of differences.
Does anyone have experience with running a data compare as a sql agent job on a server?
What kind of licensing will it take to install sql data compare on a server, and run it as a job?
(Since my license seems to be individual.)
Thanks.

Robyn

Hi, 

Thanks for your post. 

To do this using Redgate tools you would need a SQL Toolbelt license inclusive of SQL Data Compare Professional and SQL Change Automation. 

See, https://documentation.red-gate.com/sdc15/using-the-command-line/using-the-command-line-on-a-service-account-in-windows 

BenKim

Our team has 7 toolbelt licenses. Can we use that on our servers?
Or, should we purchase a separate license for each service account?
Thanks.

BenKim

Can I get some information? We have 7 toolbelt licenses. Can we install SQL compare and SQL data compare on our servers (prod and non-prod) to run sql compare or sql data comare as a batch job on sql-agents?

Robyn

Hi, 

Yes, with your 7 SQL Toolbelt licenses you can install SQL Compare and SQL Data Compare on both prod and non prod. Both tools are licensed per user!