To prepare a target database, complete the following steps.
To prepare the target database for conversion based on the target database
type, complete the following steps.
- If you are converting to Oracle, you must create the database instance before running iConvert. Refer to the appropriate Perceptive Content Server installation guide for additional information.
- If you are converting to Microsoft SQL, you must create the database shell, users, and privileges before starting iConvert by running the iConvert_SQLServer-DBOnly.sql script, which is included in the installer.
- If you are converting to PostgreSQL, you must create the database shell,
users, and privileges before starting iConvert by running the
iConvert_PostgreSQL-DBOnly.sql script, which is included in the
installer.Note:
- You do not need to create the database tables or add indexes and constraints.
- If your ODBC connection is named Perceptive Content, stop all Perceptive Content services, then rename the existing ODBC connection to prevent it from being used as your target databse. Create a new DSN named Perceptive Content for your destination databse. The iConvert installer uses a connection for your target database with the default name of Perceptive Content.