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

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

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.
BenKim
0

Comments

4 comments

Sort by
  • 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
    Robyn
    0
  • 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
    0
  • 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?
    BenKim
    0
  • 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!
    Robyn
    0

Add comment

Please sign in to leave a comment.