Synchronize schema only

SimonMazzucca

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

Brian Donahue

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.

SimonMazzucca

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

Brian Donahue

The "Include dependencies" option may be the cause of that.