Hi All, We are trying to do test migration from an on-premises sql server (2017STD) to a Azure SQL Database. Steps Taken So far Installed DMA on a on-premises local machine, ran the schema migrate option for the local DB. Resolved the issues reported and then did a schema migration to the Azure SQL Database without issue. Then ran the onsite DMA and did a Data migration using the same source local DB and destination Azure DB as was used in the Schema migration and it worked fine. Then performed the same schema migration as outlined in step1 to an newly created DB in Azure and again was successful. We then used DMS to migrate Data only from the same source local DB to the DB used in step three. But it doesn't work, we have tried a few times, but always get 'Failed input validation' Does anyone know what this Error relates to? Why can we do a Data migration using the DMA but not the DMS? Any ideas? Thanks Darren

HI, We opened a call on this and it seems the issue is in relation to different collation on the source and destination DB's. DBA is going to look at another method for migration process. Thanks for all the help Regards Darren

Azure DMS Issue 'Failed input validation'

Sliverlight 236

Hi All,

We are trying to do test migration from an on-premises sql server (2017STD) to a Azure SQL Database.

Steps Taken So far

Installed DMA on a on-premises local machine, ran the schema migrate option for the local DB. Resolved the issues reported and then did a schema migration to the Azure SQL Database without issue.
Then ran the onsite DMA and did a Data migration using the same source local DB and destination Azure DB as was used in the Schema migration and it worked fine.
Then performed the same schema migration as outlined in step1 to an newly created DB in Azure and again was successful.
We then used DMS to migrate Data only from the same source local DB to the DB used in step three. But it doesn't work, we have tried a few times, but always get 'Failed input validation'

Does anyone know what this Error relates to?
Why can we do a Data migration using the DMA but not the DMS?

Any ideas?

Thanks
Darren

Navtej Singh Saini 4,226 Reputation points Microsoft Employee

2021-02-23T01:09:38.783+00:00

@Sliverlight (Darren)

Please confirm you have gone through these documents (document1, document2 ) and followed the same for migrating the databases.

Also as you are getting Failed Input error, does it give which input has failed.

Regards
Navtej S
Sliverlight 236 Reputation points

2021-02-23T12:41:47.16+00:00

@Navtej Singh Saini

I have gone through documents as outlined. I'm not seeing any issues in path I'm currently taking.

In relation to the error, no I don't get any further information on what has failed. DMS doesn't give any detail.

Regards

Darren
Navtej Singh Saini 4,226 Reputation points Microsoft Employee

2021-02-25T02:24:02.173+00:00

@Sliverlight

At this time we will suggest you contact support as they will have access to the telemetry and resources as well.

Please share your ticket number and we will try to get traction for this issue.

Regards
Navtej S
Navtej Singh Saini 4,226 Reputation points Microsoft Employee

2021-02-26T04:19:42.96+00:00

@Sliverlight Were you able to create the support ticket.
Sliverlight 236 Reputation points

2021-02-26T11:35:26.89+00:00

@ NavtejSaini-MSFT

Hi, I only managed to get some time to create the ticket this morning. Case ID is 2102260050001096

Regards

Darren

Accepted answer

Sliverlight 236 Reputation points

2021-03-01T12:04:10.147+00:00

HI, We opened a call on this and it seems the issue is in relation to different collation on the source and destination DB's. DBA is going to look at another method for migration process.

Thanks for all the help

Regards

Darren
Please sign in to rate this answer.
Navtej Singh Saini 4,226 Reputation points Microsoft Employee

2021-03-02T02:44:52.763+00:00

@Sliverlight - Thank you for confirming the issue and the resolution.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure DMS Issue 'Failed input validation'

0 additional answers

Your answer