How to migrate a Gen CSE Oracle database to SQL Server
search cancel

How to migrate a Gen CSE Oracle database to SQL Server

book

Article ID: 141168

calendar_today

Updated On:

Products

Gen

Issue/Introduction

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

Environment

Release : 8.6
Component : Gen Client Server Encyclopedia

Resolution

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 Gen™ 8.6 > Encyclopedia > Client Server Encyclopedia > Use the Client Server Encyclopedia > Encyclopedia Communication > Encyclopedia Communications Tasks 
See sections "Copying a Model from Another Encyclopedia" and "Manually Copying a Model from a CSE to a CSE While Preserving Common Ancestry"

Additional Information

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