General Considerations for Using CA ERwin Data Modeler Workgroup Edition › Conversion Notes for Oracle, Microsoft SQL Server, and Sybase
Conversion Notes for Oracle, Microsoft SQL Server, and Sybase
Review the following information before you attempt a CA ERwin Data Modeler r7.x to r8 database conversion.
For Oracle r7.x databases:
- Make sure you have at least as many rollback segments as used by your r7.x database. We strongly recommend that you follow the guidelines in the CA ERwin Data Modeler Workgroup Edition Administration Guide.
- Before you start a conversion, it is strongly recommended that you shrink rollback segments. The following is a sample SQL statement (for each segment):
ALTER ROLLBACK SEGMENT <RBS_NAME> SHRINK;
It is safe to randomly shrink rollback segments while the conversion is running, but you must be logged in as the DBA.
For Microsoft SQL Server and Sybase r7.x databases:
- tempdb should be as big as the mart DB size.