CODEWITHSUNDEEP
mysqlsql-serverazure-data-factory
morris295
morris295

Reputation: 547

Azure Data Factory Copy Task Creates Gap In IDs

I have an Azure DataFactory copy task set up to copy employee data from a MySQL database to a SQL Server database. The data copies over fine except for the fact that the copy operation creates a huge gap in the ID values when copying. As you can see in the image here, the ID values jump from 1689 to 2410 without any apparent explanation. When I select from the table in MySQL the IDs are displayed in the proper sequence, but once I do this copy task it creates this bizarre gap. I've done quite a bit of googling and reading the docs to try and figure out why this is happening with no luck. I'd love any help someone could provide.

example

Upvotes: 0

Views: 96

Answers (1)

SureshBabu
SureshBabu

Reputation: 474

@morris295, thank you for updating the source of the problem and resolution in the comments, posted your valuable discussion as an Answer to help other community members.

There were some gaps found in between the IDs range in the testing instance due to some inserts/deletes performed on the data. This issue does not exist in the production instance and Ids did not have any gaps in between.

enter image description here

Upvotes: 1

Related Questions