Related Topics: | ||
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.
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.
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:
Server Name: The name of the Microsoft SQL Server implementation where the new database will be created. Note that if you are using SQL Server Express, the server name is usually your login for that computer followed by \SQLEXPRESS (e.g., Username\SQLEXPRESS).
Database Name: The name of the new database that will be created.
If you choose Oracle, you will be required to enter:
Port, Host and Service identifiers for the Oracle server where the new database will be created.
The Schema of the new Enterprise database.
The Password for the new enterprise database schema.
The administrative username and password for the Oracle server (entered in the Admin Information area).
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.