Oracle to SQL Migration - how to migrate custom tables

[HM_12234470]

Version: Windchill 13.0

Use Case: The O2S tool migrates only OOTB tables and not the custom tables. anyone performed the O2S migration before and can help answering this query?

Description:

Have gone through lot of articles and migration guide. However, could not find information related to migrating custom tables from Oracle to SQL. The O2S tool migrates only OOTB tables and not the custom tables. anyone performed the O2S migration before and can help answering this query?

[MTH]

@HM_12234470 ,

We went through the same conversion in many occasions. For the custom tables, you need to do the conversion yourself(convert Oracle DDL to SQL Server), export the data from the oracle table and import it in sql(multiple techniques could be used for this purpose), then recreate the contstraints and keys in the new sql table. 

[HM_12234470 · Accepted solution]

We can use the SQL Server Migration Assistant (SSMA) for Oracle which is a free Microsoft-supported tool that automates and simplifies the process of migrating Oracle databases to SQL Server, Azure SQL Database. We used it and able to migrate the custom tables.