using sqlcompare command line to generate scripts for backup

dma550

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

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 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.