SQL/Server Connection

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

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:

• https://docs.microsoft.com/en-us/previous-versions/sql/legacy/ms378428(v=sql.90)
• http://www.connectionstrings.com/