SQL Editor for writhing SQL on Source and Target tables

Syd

Is there an option to join two or more tables whether in source or target to build a list of columns to compare that are residing on different tables. This is to validate a logical work unit vs physical table compare.

Also can a script be built that can be run through scheduler to run at a specific interval?

Thanks

Kurt_M

Hi @Syd

Unfortunately, you can only map 1 table from the source and target servers when using SQL Compare. It automatically selects the tables to map to, but if required, you can manually map different tables to one another if needed.

As for the script, this is possible to create. You can write a script, save it as a batch file and then run it through something like task schedular to run it at the specific interval you require. 

Syd

Hi Kurt,

Thanks for your response on my question. Another related questions is that once a number of tables are selected for comparison or even the entire database, how are the comparisons run, sequentially or using parallel processing?

Regards

Syd

Kurt_M

Hi @syd,

The comparison would be run like any other SQL script, in a sequential manner. Once you select the tables for comparison, if you have a look at the script that gets generated before deploying the changes, then you'll see exactly the order it gets generated in.