How to migrate a CA Gen CSE Oracle database (schema) to a Microsoft SQL Server database

book

Article ID: 141168

calendar_today

Updated On:

Products

CA Gen

Issue/Introduction

Does CA Gen have a utility to unload a CA Gen CSE Oracle database (schema) and reload into a Microsoft SQL Server database?

Environment

Release : 8.6
Component : CA Gen Client Server Encyclopedia

Resolution

CA Gen doesn't provide a utility to migrate a CSE Oracle database to a corresponding Microsoft SQL Server database.
Theoretically one possibility is to use the "Microsoft SQL Server Migration Assistant for Oracle (OracleToSQL)":
https://docs.microsoft.com/en-us/sql/ssma/oracle/sql-server-migration-assistant-for-oracle-oracletosql?view=sql-server-ver15
However from a CSE operational perspective the conversion from the source Oracle schema to the target SQL Server database structure may not result in what would be created by a vanilla CSE SQL Server installation and thus the CSE software may not run as expected.

The supported method for the CSE Oracle to SQL Server migration is to use download with upload + extract options for all models.
The extract option means that ancestry data will be maintained and adoptions will not be required in the new CSE.
NOTE: To prevent any ancestry related corruption problems in the new CSE it must have a different ENCY ID compared to the original CSE.

For further details on download with upload + extract see CSE "Encyclopedia Communications Tasks" in the Gen 8.6 techdocs i.e.
Encyclopedia > Client Server Encyclopedia > Use the Client Server Encyclopedia > Encyclopedia Communication > Encyclopedia Communications Tasks
See section "Copying a Model from Another Encyclopedia" and "Manually Copying a Model from a CSE to a CSE While Preserving Common Ancestry"


Additional Information

This KB article (Introduction section) covers the need for unique Encyclopedia IDs: CA Gen Encyclopedias and the importance of unique Encyclopedia IDs