Upgrade › How to Upgrade the Mart
How to Upgrade the Mart
It is important to run through the upgrade process in a test environment before attempting to upgrade your production environment. By doing so, you become aware of any challenges that exist, and have fewer surprises when you actually convert your production environment. To convert your mart as efficiently and as fast as possible, follow these recommendations:
- Make a full backup of the current database using the backup utility for your DBMS before upgrading.
- Open and save all models in your mart using the current version of the client before you convert to CA ERwin Data Modeler Workgroup Edition r8.
- Ensure that all users check in any off-line models and ensure that there are no active sessions on the mart and that no models are checked out.
- Remove obsolete models in the current database to reduce the size, which improves the conversion speed.
- Verify that CA ERwin Data Modeler models are synchronized if you synchronize data.
- Verify that your client version is compatible with the database version to which you are migrating.
- Increase the size of the database to a minimum of three times the size of the previous database for temporary conversion objects.
- Verify there are no outstanding technical support issues related to CA ERwin Data Modeler Workgroup Edition.
- Turn on AUTOEXTEND to automatically extend the CA ERwin Data Modeler Workgroup Edition data file when full (Oracle DBMSs only).
- Make sure the Auto grow file is turned on, with your choice of File Growth and unrestricted File Growth for both data files and transaction logs (SQL Server 2000 DBMSs only).
- Review the Release Notes file.
- Run the upgrade during off-peak hours.
- Truncate the database log file.
- Start the conversion from the server to eliminate the possibility of network speed becoming a bottleneck. Have at least 1 GB on the client, typically more memory means faster performance.
- Log on to your DBMS as either the dbo (Microsoft SQL or Sybase) or schema owner (Oracle) of the database that contains the mart.