Options

SQL Editor for writhing SQL on Source and Target tables

SydSyd Posts: 2 New member
in SQL Data Compare
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
Tagged:
· Share on Twitter

Best Answer

  • Options
    Kurt_MKurt_M Posts: 178 Silver 1
    Answer ✓
    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. 

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

    · Share on Twitter

Answers

  • Options
    SydSyd Posts: 2 New member
    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


    · Share on Twitter
  • Options
    Kurt_MKurt_M Posts: 178 Silver 1
    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.

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

    · Share on Twitter
Sign In or Register to comment.