Related Topics:

Enterprise Repositories

Upgrading an Enterprise Repository from Version 8

If you have an existing enterprise database that was created with any of the Version 8 Synthesis applications, an administrative user can transfer all of the existing data into a new database that is compatible with the Version 9 applications.

To open the Upgrade Version 8 Enterprise Repository window from any Version 9 application, choose File > Manage Repository > Upgrade Repository.

Synthesis 8 Repository to Be Upgraded

Use the left side of the window to specify the Version 8 enterprise database that you wish to upgrade. Note that you must have Admin level permissions in this database in order to be able to transfer all of the data. If you do not have sufficient permissions in the selected database, a message will be displayed when you attempt to perform the upgrade process.

Synthesis 9 Repository to Be Created

Use the right side of the window to define the new Version 9 enterprise database that the existing data will be transferred into. All of the same requirements for creating a new enterprise database apply here (e.g., you must have an established database server and the necessary permissions to create a database on the server).

You can choose to create the new database in either Oracle or Microsoft SQL Server, even if the existing Version 8 database resides in the other database platform. (In other words, it is possible to upgrade a database from SQL Server to Oracle, or from Oracle to SQL Server, if desired.)

If you choose SQL Server, you will be required to enter:

If you choose Oracle, you will be required to enter:

Click OK to start the upgrade. When the process completes, the prior Version 8 database will remain unchanged and there will be a new Version 9 database that contains all of the existing data.

IMPORTANT for SQL Server Databases: The username must be associated with a "SQL Server Login" that allows the database platform to recognize the user and give access to the application database. This can be accomplished with an individual login, a group login or Windows impersonation. (See SQL Server Logins or Using Windows Impersonation.)

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.