Options

Synchronize schema only

SimonMazzuccaSimonMazzucca Posts: 3
edited July 3, 2014 4:39AM in SQL Data Compare Previous Versions
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
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • Options
    SimonMazzuccaSimonMazzucca Posts: 3
    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
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    The "Include dependencies" option may be the cause of that.
    · Share on Twitter
Sign In or Register to comment.