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

SQL Editor for writhing SQL on Source and Target tables

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
Sajid
0

Comments

3 comments

Sort by
  • 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.
    Kurt_M
    0
  • 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


    Syd
    0
  • 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.
    Kurt_M
    0

Add comment

Please sign in to leave a comment.