Options

how can i compare a table with null table in SQLDataCompare

jubayer92jubayer92 Posts: 4
edited December 21, 2010 9:11PM in SQL Data Compare Previous Versions
i was trying to get sql insert scripts for all records for a table using SQLDataComparere SDK. I am comparing the table with a null as ComparisonSession.CompareDatabases() takes null for targetdatabase. however i am not getting any scripts. Is it the right way to accomplish that? or there is a better way. please advise...
· Share on Twitter

Comments

  • Options
    Chris AucklandChris Auckland Posts: 769
    Thanks for your post.

    I'm not sure that method will work as you will need to 'map' the table to another table in the target. If the other db is null, then there won't be anything to map to.

    If you don't want to use another blank copy of the same database to map to, then you might be better off using the synchronize to scripts functionality.

    You can see an example of this in the patch SDK that you can get from here.

    The example that should be able to help you is 'StaticDataWithScriptsExample'

    I hope this helps.
    Chris
    · Share on Twitter
  • Options
    Christopher P. SpillmanChristopher P. Spillman Posts: 1
    Thanks for posting your articles. Hope to gather more information about the data you have posted. I will be glad reading more of this page.
    · Share on Twitter
Sign In or Register to comment.