Migrating SQL Server data

Rational ProjectConsole Maintenance Tool Help  

To provide information about the SQL Server data to migrate:

  1. In the Data warehouse information:

    a. From the Database type list, select the SQL Server database type.

    b. In the Database server field, enter the machine name of the server where the SQL Server database is running.

  2. In the Schema repository:

    a. In the Name field, enter the name of the database for the schema repository.

    b. In the Username field, enter the user name required to log in to your SQL Server schema repository.

    c. In the Password field, enter the password required to log in to your SQL Server schema repository.

  3. In the Data warehouse:

    a. In the Name field, enter the name of the database for the data warehouse.

    b. In the Username field, enter the user name required to log in to your SQL Server data warehouse.

    c. In the Password field, enter the password required to log in to your SQL Server 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.