Create INSERTs for the missing destination table?

Compares and synchronizes SQL database content.

Create INSERTs for the missing destination table?

Postby JureP » Wed Jul 24, 2013 11:31 am

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
JureP
 
Posts: 3
Joined: Fri Jul 19, 2013 4:45 pm

Postby james.billings » Wed Jul 24, 2013 12:38 pm

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?
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron