x

You should perform this procedure if you did not yet define the target repository or if you are migrating from a different source repository than the default HSQL repository.

If you are migrating the default HSQL repository into a new repository, the source repository is already defined for you. If you performed the steps in How to Enter Connection Information for Service Manager, then you probably already defined the target repository. If you do not need to define the source or the target, proceed to How to Start the Migration.

To define the source and target repositories as Data Providers:

1. Open the iWay Service Manager Administration Console and log on:

   http://hostname:9999

   where:

   hostname

   Is the host name where you installed iWay.

2. In the left pane, click Data Provider.
3. Click Add under the JDBC Connections box.

   A form appears for defining the database. Define the source or target repository.

4. Complete the fields as explained in the following table:

   Parameter	Description
   Name	Enter a name that you will use to refer to the connection.
   Driver Class	Use the drop-down menu or manually enter the JDBC Class.
   Connection URL	Use the drop-down menu and edit the default URL. You can also manually enter the URL. For examples, see How to Enter Connection Information for Service Manager. For SQL Server 2000, ensure the URL ends with the following: ;SelectMethod=cursor
   User	Provide the user ID to access the repository database.
   Password	Provide the password to access the repository database.

5. Click Test.

   You should receive a response that says:

   The JDBC data provider test completed successfully.

   If you receive an error, troubleshoot accordingly. Ensure the driver is in the iway7\lib directory, as explained in How to Install the JDBC Driver.

6. Click Add if the test is successful.

   You connection appears on the Data Provider page. If you need to change its parameters, you can click its link.

7. If you need to define both the target and source repositories, repeat this procedure to define another repository.

x

1. If it is not open, open the iWay Service Manager Administration Console and log on.
2. In the left pane, click Services Provider.

   The currently selected Data Store Type and Data Provider Name determines the source repository.

3. If it is not already selected, set the source repository by changing the Data Store Type and Data Provider Name and clicking Update. The Data Provider Name is the name you used when you defined the source repository.
4. Set the target repository by changing the Data Store Type and Data Provider Name.
5. Then click the Migrate hyperlink.

   A page displays information about the migration. If the source and destination (target) are not correct, click Services Provider on the left to correct them. If your new database has data in it that you wish to delete, you can select the Reset/Clean Destination option.

6. Click Migrate if the source and destination (target) are correct.

   Information about the migration appears. Ensure that there are no critical errors.

   After the migration completes, iBSP is set to use the source repository. You should set it to use the target repository instead.

7. Click Services Provider on the left.
8. Change the Data Store Type to the type of repository you wish to use.
9. Set the connection you just defined as the Data Provider Name.

   Note: Connection Pooling is not supported with SQL Server 2005.

10. Restart iWay Service Manager.