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: