MS SQL Migration Steps

To migrate from the C++ MS SQL connector to the Java MS SQL connector, you must do the following:

Install the MS SQL Java connector using the Java CS installation
You can remove your DSN if it is not being used for another other purpose
Add the URL as defined in Configure the JDBC URL to each existing MS SQL endpoint. To do this, right click on each endpoint and select “Custom… -> Change Admin Password” and supply the URL in the JDBC URL field.

Once this has been done, all types of operations can be executed against the existing MS SQL endpoints seamlessly.