To transfer data from a JP1/Software Distribution Manager basic database JP1 Version 7i or earlier to a relational database, first create a new relational database, and then transfer the contents of the basic database to the new relational database.

For the limitations on migrating the basic database to a relational database, see 7.4.2(1) Configuration limits when transferring data to a relational database.

Note

• If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
  

  World Wide Web Publishing Service or World Wide Web Publishing Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)

  To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from that listed above.
  
• If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before transferring administration files from the file system.
• If you changed the package storage directory when you transferred data from a basic database to the relational database, move files from the previous package storage directory to the new package storage directory, and then follow the procedure below.

To transfer data from a JP1/Software Distribution Manager basic database JP1 Version 7i or earlier to the relational database:

1. In the Welcome dialog box, choose Relational database system to be used, Transfer administration file from the file system, and then click the Next button.
   The Transfer Data to Relational Database dialog box appears.
   

   Figure 7-34 Transfer Data to Relational Database dialog box

   

   To change the JP1/Software Distribution installation directory or the package storage directory, click the ... button next to that item. To transfer packages, select the Package storage directory check box.
   
2. Click the Execute button.
   The system transfers the data from the JP1/Software Distribution Manager basic database to the relational database.