Activity overview
Latest activity by Larry Irving
SQL Compare Database names using the /report: feature
We are using SQL Compare to compare point-in-time database snapshots. Each night we create a new snapshot and compare that snapshot to the most recent snapshot that exists from previous runs of th...
I figured it out.
Instead of using:
cmd /C "C:\Program Files\Red Gate\SQL Bundle 5\SQLCompare.exe" /database1:db name /makesnapshot:\\server\share
\snapshots\db_name.snp
I changed it to the old sytle path like this and I was able to use quotes around the parameters instead of the executable path:
cmd /C c:\progra~1\redgat~1\sqlbun~1\SQLCompare.exe "/database1:dn name" /makesnapshot:\\server\share
\snapshots\db_name.snp
I also replace any spaces in the /makeshapshot: parameter with _, otherwise I probably would have needed quotes around that as well.
Thanks. / comments
I figured it out.
Instead of using:
cmd /C "C:\Program Files\Red Gate\SQL Bundle 5\SQLCompare.exe" /database1:db name /makesnapshot:\\server\share
\snapshots\db_name.snp
I changed it to the old syt...
Command Line scripting with a space in the DB name
First off, I'm a new user to the product and I think it's great. It will give us the daily schema compares we've been looking for (due to auditory regulations) for awhile now.
Anyway, what we have...