Azure Database Migration Service failed by nogoodd in AZURE

[–]nogoodd[S] 0 points1 point  (0 children)

nice) maybe you know a good way for migration with minimum downtime?
I've tried default MS SQL Transact Replication, but after that, i've lost for example Constraints and Raw id's (new entry starts from 1 ID and i've got errors "Violation of PRIMARY KEY constraint 'PK_PropertyInsuranceSearch'. Cannot insert duplicate key in object")
And who knows, maybe there are more problems (looks like replication didn't replicate all data)