I am looking to migrate an Oracle database to a MS SQL Server database and I need to know what are the constraints related to the Dimensions CM schema or code page.
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
I am looking to migrate an Oracle database to a MS SQL Server database and I need to know what are the constraints related to the Dimensions CM schema or code page.
Hi Michel,
I know we also replied to you via case 02155254 on this. We do not provide a migration from Oracle to SQL Server in the same way we do for Oracle to PostgreSQL. The issue is if your Oracle database is Unicode then there is likely to be an issue during data conversion as Dimensions CM is not able to store UTF-8 data in SQL Server at present. SQL Server 2019 introduced native support for UTF-8 encoding but we do not fully support that within Dimensions CM yet.
Hi Michel,
I know we also replied to you via case 02155254 on this. We do not provide a migration from Oracle to SQL Server in the same way we do for Oracle to PostgreSQL. The issue is if your Oracle database is Unicode then there is likely to be an issue during data conversion as Dimensions CM is not able to store UTF-8 data in SQL Server at present. SQL Server 2019 introduced native support for UTF-8 encoding but we do not fully support that within Dimensions CM yet.