SQL serve migration DMA result suggestion?

• Saran

  Right there with Babe

  Points: 760

  More actions

  September 4, 2023 at 10:08 am

  Go to Answer

  #4279142

  Hi All,

  I am planning to migrate SQL server from old to new server and run the DMA found some Breaking changes, Behavior changes and information message.

  For breaking changes - I can understand  developer needs change the query as per suggestion.

  Can we leave Behavior changes as it is ?

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 5, 2023 at 10:10 am

  #4279756

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  September 5, 2023 at 10:18 am

  Answer

  #4279759

  No you should not leave them as is.

   

  Anything DMA spits out as an issue you need to investigate what that issue is.

  Note where that piece of code lives in the calling application.

  Test that piece of code in dev/test after the upgrade and ensure that the results both from then query/application perspective haven't changed in some way due to the behaviour change and that the app still functions correctly.

   

   

• Saran

  Right there with Babe

  Points: 760

  More actions

  September 5, 2023 at 11:12 am

  #4279774

  Thanks for the update. It helps us.

  I will ask developer to fix that as well.

  Most of them are old join syntax Table1, Table2.

  • This reply was modified 1 year, 2 months ago by  Saran.