Comments
2 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 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. -
Hi Larry,
Normally this would work. Perhaps if you are using an older OS like Windows NT, this could be necessary. Otherwise, it could be down to having 'command extensions' disabled in your cmd configuration.
Add comment
Please sign in to leave a comment.
Anyway, what we have is a script that will run each night and create snapshots of our databases. The following works fine for us (called from a vbscript using the objshell.run method):
cmd /C "C:\Program Files\Red Gate\SQL Bundle 5\SQLCompare.exe" /database1:db_name /makesnapshot:\\server\share\snapshots\db_name.snp
But we've also got some databases with a space in their name. When we try to run the command:
cmd /C "C:\Program Files\Red Gate\SQL Bundle 5\SQLCompare.exe" /database1:db name /makesnapshot:\\server\share\snapshots\db name.snp
The script fails because it's trying to connect to a database named db. Is there a "wrapper" I can use like [db name]?
We've tried various other options as far as quoting the parameters passed into the sqlcompare.exe program and either the cmd command fails or the /database: parameter only interprets the db name to the space.
Any ideas?
Thanks,
Larry