I have some pretty specific questions about TOad for SQL Server.
- Can I run a schema compare unattended from the command line (e.g. from a batch job)?
- Can I run a data compare unattended from the command line (e.g., from a batch job)?
- When running a schema or data compare from the command line, can I specify specific ojects that the compare should ignore? Are there restrictions on what types of objects can be ignored?
Yes to all three. Toad products are command-line callable, and can execute a variety of things depending on each product's command line flags. In your case, it's best to define an automation script within Toad (to perform your various compares), save your automation script, and then call it up via command line from your batch file. See screen snap below.
Another way to get this done is to perform the Compare within Toad, including any object subset you define within the Compare wizard, and once you're satisfied that the Comparison does what you need, hit the Automation button in the upper right hand corner of the Compare tab. See screen capture below.
1 Like
