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

Path to snapshot - invalid command line argument

Hello!

I want to call SQLCompare.exe with a command line argument for a snapshot. If I only use the filename (file in same directory as exe) all works fine. But when the file is in another directory I get an error:

works:
SQLCompare.exe /server2 SERVER/database2 DATABASE /username2 SA /password2 PASSWORD /snapshot1 SNAPSHOT.snp /sync

does not work:
SQLCompare.exe /server2 SERVER/database2 DATABASE /username2 SA /password2 PASSWORD /snapshot1 d:/SNAPSHOT.snp /sync

I also tried:
SQLCompare.exe /server2 SERVER/database2 DATABASE /username2 SA /password2 PASSWORD /snapshot1 'd:/SNAPSHOT.snp' /sync
SQLCompare.exe /server2 SERVER/database2 DATABASE /username2 SA /password2 PASSWORD /snapshot1 "d:/SNAPSHOT.snp" /sync
SQLCompare.exe /server2 SERVER/database2 DATABASE /username2 SA /password2 PASSWORD /snapshot1 d:\SNAPSHOT.snp /sync
...

the error message is: Error: Invalid command-line argument

What is the correct syntax for file paths?

Regards
Susanne
Suleon
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi Susanne,

    I think it should be: 
    SQLCompare.exe /server2:"SERVER\database2" /database2:DATABASE /username2:SA /password2:PASSWORD /snapshot1:"d:/SNAPSHOT.snp" /sync
    I'm not sure why the word DATABASE is hanging out all on its' own. I think SQL instance names should always be separated by a backslash rather than a forward-slash.

    Hope this helps!
    Brian Donahue
    0
  • Suleon
    Hi Brian,

    I overlooked the colon. With that and the quotes now all works fine.

    The DATABASE belongs to /database2. I just forgot a space.

    Thank you!

    Susanne
    Suleon
    0

Add comment

Please sign in to leave a comment.