Synchronize schema only

Compares and synchronizes SQL database content.

Synchronize schema only

Postby SimonMazzucca » Fri Jun 27, 2014 5:55 pm

I have tables in the source DB that have new columns. I want to propagate that to the target DB, but the data should not be copied.

How do I sync just the schema ?

Thank you,
Simon
SimonMazzucca
 
Posts: 2
Joined: Fri Jun 27, 2014 5:52 pm

Postby Brian Donahue » Mon Jun 30, 2014 12:30 pm

SQL Compare can (and does) synchronize the schema. Data Compare is for synchronizing data, although it does seem to have some limited schema synchronization in later versions, just for the purpose of making it easier to copy the data.

Hopefully this helps.
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Postby SimonMazzucca » Mon Jun 30, 2014 8:32 pm

Excellent, thank you very much.

I have a follow up question, though:

In SQL Compare, I have about 10 tables that are only in the source DB. I select about 5 of those, and deploy. All good.

Then if I save the SCP project and execute it, ALL tables get copied over.

This is my command line:
"C:\\Program Files (x86)\\Red Gate\\SQL Compare 10\\sqlcompare" /project:QA_to_Prod.scp /Synchronize

How do I sync just the tables selected in the project ?

Thank you,
Simon
SimonMazzucca
 
Posts: 2
Joined: Fri Jun 27, 2014 5:52 pm

Postby Brian Donahue » Thu Jul 03, 2014 9:39 am

The "Include dependencies" option may be the cause of that.
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests