Hi,

I am migrating a database from oracle to sql server using SSMA.

The database migration went successful there were no errors.

However, I later checked that there are CHECK type contraints created and enabled on several

tables in oracle database, but when I checked in sql server these constraints are not present.

Although primary key constraints are migrated during schema migration using SSMA.

Please suggest how can I migrate these CHECK constraints from oracle to sql?

Thanks.

Hi ManiC24,

As indicated in this migration guide, during the conversion, all indexes, constraints, and triggers defined for a table in Oracle are converted to SQL Server.

From your description, CHECK constraints are not present in SQL Server, could you please check that if these CHECK constraints are enabled in Oracle during the migration process? Also make sure that you perform all the steps in this similar blog to migrate Oracles schema to SQL Server.

In addition, please note that SSMA for Oracle cannot convert the schema of a table having a constraint condition which is checking for NAN values. In this case, we need to manually modify the table definition. For more details, please review this blog.

Thanks,
Lydia