Database parameters for migrating SQL Server data

Rational ProjectConsole Maintenance Tool Help  

Provide the following information about the SQL Server databases that contain the data you want to migrate.

In the Data warehouse information:
In the Schema repository:
In the Data warehouse:

Database connection options:

The arguments that can be entered in the Connect Options field for SQL Server are PORT and INSTANCE. Rational ProjectConsole uses port number 1433 as the default port. If the port number of the database is different from the default, then the port number should be entered in this field in the form PORT=port_number. Argument names are not case sensitive, but the values are case sensitive. Arguments must be separated by semicolons, with no spaces in between.

Rational ProjectConsole also uses the default instance, which generally uses the same setting as the default port number. For SQL Server databases on Windows, you can specify an instance other than the default in the form INSTANCE=instance_name.