Question about Using Data Migration Assistant when moving database from SQL Server to Azure SQL database.

• BoobyB

  SSCertifiable

  Points: 5470

  More actions

  September 14, 2017 at 7:53 am

  #339228

  Hello All,

  when using Data Migration Assistant to check compatibility of database between SQl Server and Azure SQL database, we get in the issues table three headings:

  - Migration blockers
  - Behavior changes
  - Deprecated feature
  

  I am trying to understand what the meaning of these three heading. This is my understanding so far and would really appreciate feedback on this.

  - Migration blocker - This will be, migration will not happened until issues mentioned in this section are not resolved.
  - Behavior Changes -  Migration can happen, however, alternates are available . In my case, it i saying that windows uses can not be migrated to use SQL login.
  - Deprecated -  I am getting messages saying "These data types are checked as deprecated. In some cases, using TEXT, IMAGE or NTEXT might harm performance."
   Migration can happen but it's better to change the data type to the new  varchar etc ...
   

  would like to know if this is correct or it has a different interpretation

  regards,
  B

• BoobyB

  SSCertifiable

  Points: 5470

  More actions

  September 14, 2017 at 9:32 am

  #1959459

  Anyone?

  I am sure some have used DMA before.

  Regards,
  B