Red Gate forums :: View topic - Create INSERTs for the missing destination table?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Create INSERTs for the missing destination table?

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JureP



Joined: 19 Jul 2013
Posts: 3

PostPosted: Wed Jul 24, 2013 11:31 am    Post subject: Create INSERTs for the missing destination table? Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Wed Jul 24, 2013 12:38 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group