Connection String for command line snapshot creation

[mango333]

The documentation is a bit lacking with regards to what is required for the connection string for the various commandline arguments of the Schema Compare product (4.0.32). What works for setting the /source and /target for a schema compare, does not work when creating a snapshot.

What I found out, quite by accident, is that if I went into the GUI and created my connections and then referenced them in the server argument of the /connection switch, it worked just dandy. I'm finalizing evaluation phase and spent waaaay too much time trying to figure this out when it could have been so simple.

Here is an example of my PowerShell command:

Code: Select all

PS C:\Program Files\Devart\dbForge Schema Compare for SQL Server> .\schemacompare /snapshot /compress:True /connection:server=DW /database:SomeDB /file:"i:\Snapshots\SomeDB_Snapshot.snap"

DW is an alias (properly configured on the server) and I want to connect with Integrated Security=True, which should be the default. However, prior to creating the DW connection in the GUI with the Connection Manager, this line generated the following error -

Error: Login failed for user ''.

I tried adding the Integrated Security=True and received a /connection invalid error.
I tried adding my User ID (even though we don't use SQL Server Logins) and received a /connection invalid error.
I tried using the full connection string I've used successfully for setting /source and /target connections and I get a /connection error.

Can dbForge support beef up the documentation with regards to connection strings, particularly what is required if you don't want to use the GUI at all?

[alexa]

Please use the connection string retrieved from the 'Connection Manager' dialog that can be opened by selecting 'Database -> Connection Manager...' from the main menu.