Create INSERTs for the missing destination table?

JurePJureP Posts: 5
edited July 24, 2013 7:38AM in SQL Data Compare Previous Versions
Hi!

Is there a way to persuade/trick SQL data compare to also include tables that are missing from destination database?

I just need simple INSERTs for each row in the source table(s).

Thanks,
Jure
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Not really I'm afraid.

    To work out what needs to be inserted, Data Compare has to run the comparison, which means it successfully needs to have mapped the source and target together.

    You could try creating a set of scripts of your source DB, then comparing the DB > Scripts.

    That should create a sync script with all the inserts in it that you could then take and run against another database that does have the table?
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.