SQL/Server Connection

Prior to running CopyStorm for the first time, create a fresh SQL/Server database.

SQL/Server Connection String

The only difficult part when copying Salesforce to SQL/Server is constructing the connection string. Clicking on the Connection String Builder will open a form that, if you are running SQL/Server using a standard configuration, will construct a connection string for you.

The connection string can be verified by pressing the “Test SQLServer Connection” button.

The general form of a SQL/Server connection string is:

  • [server-name[\instance-name][:port-number]][;property=value]*

If you would like to see more information regarding SQL/Server connection strings or are not familiar with Microsoft’s type 4 JDBC driver, these resources may help: