How to copy the indexes and constraints from the source database?

Question

How to copy the indexes and constraints from the source database?

Rahul 251

Hi,

I am migrating the data from oracle to the azure sql database.

From ADF functionality -Auto create , I am able to create the table successfully.

How to create/copy the indexes and constraints from the oracle source to the azure sql database through ADF tool ?

I understand above can also be achieved through sql scripts as one of the options.

OGINTZ Marina 175 Reputation points

2024-02-20T11:28:04.5266667+00:00

I would like to know if you succeed and how did you do it.
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-02-20T21:05:39.8866667+00:00

OGINTZ Marina Is your question around. Create/copy the indexes and constraints from the oracle source to the azure sql database through ADF tool?

Accepted answer

0 additional answers

Your answer

OGINTZ Marina 175 Reputation points

2024-02-20T11:28:04.5266667+00:00

I would like to know if you succeed and how did you do it.
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-02-20T21:05:39.8866667+00:00

OGINTZ Marina Is your question around. Create/copy the indexes and constraints from the oracle source to the azure sql database through ADF tool?

Answer 1

Nandan Hegde 36,151 MVP Volunteer Moderator

Hey, In case of auto create only the schema gets created and not the constraints or indexes as you rightfully identified. You would have to use script activity initially on the source database to check whether there are any indexes or constraints on the table and get their definitions. Post that you need to use script activity on sink database to execute those definitions covered / identified in prev step on source database.

OGINTZ Marina 175 Reputation points

2024-02-20T11:28:57.62+00:00

In case we are not using auto create it will create the indexes?
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-02-20T21:02:50.11+00:00

OGINTZ Marina Please see this https://learn.microsoft.com/en-us/answers/questions/1366948/data-migration-from-oracle-to-azure-sql-database-t If you’re not using auto-create for table creation in Azure Data Factory (ADF), the indexes won’t be automatically created. In such cases, you’ll need to explicitly define and create the indexes for your Azure SQL Database tables.

Share via

How to copy the indexes and constraints from the source database?

0 additional answers

Your answer