Synchronize schema only

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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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 DonahueBrian Donahue Posts: 6,590 New member
    The "Include dependencies" option may be the cause of that.
Sign In or Register to comment.