how can i compare a table with null table in SQLDataCompare

jubayer92

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...

Chris Auckland

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.

Christopher P. Spillman

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.