using sqlcompare command line to generate scripts for backup

dma550dma550 Posts: 10
edited January 28, 2013 4:36AM in SQL Compare Previous Versions
Hey guys

I have some large databases I develop regularly. I dont want to backup (via Mozy) the database itself, but all the DDL has importance to me. I cannot use a source control provider at this time.

I want to schedule a script dump daily and have Mozy pick it up. However, it would be nice that if the DB objects dont change that Mozy doesn't have to process them. I tried this
sqlcompare  /Database1:MyDBName /Makescripts:"c:\sqldata\scripts\mydbname"

but got
Error: The folder 'c:\sqldata\scripts\myDB' exists. SQL Compare cannot
dump scripts from a database into a folder that already contains data. Use the
/synchronize option if you want to merge scripts into an existing folder.

If I am to pull this off right, do I need to do this to a temp area and /sync it to another file? Can anyone supply an example?

Comments

  • I did figure this out - I created a work folder, do a script to it. Then, I do a /sync /force between the folders, and only the changed files are touched. Then, these are picked up by Mozy as deltas.
  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and solution.

    I am glad that this worked for you.

    Kindly let us know if you have any other issues or questions regarding SQL Compare,I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.