How can we help you today? How can we help you today?

using sqlcompare command line to generate scripts for backup

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?
dma550
0

Comments

2 comments

Sort by
  • dma550
    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.
    dma550
    0
  • Anu D
    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.
    Anu D
    0

Add comment

Please sign in to leave a comment.