Skip to main content
H
HM_1223447010-Marble
10-Marble
February 25, 2026
Solved

Oracle to SQL Migration - how to migrate custom tables

  • February 25, 2026
  • 1 reply
  • 43 views

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?

Best answer by HM_12234470

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.

1 reply

M
MTH13-Aquamarine
13-Aquamarine
March 4, 2026

@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. 

 

H
HM_1223447010-MarbleAuthorAnswer
10-Marble
March 4, 2026

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.

    Terms & ConditionsCookie settingsAccessibility statement