locked
Microsoft® Data Migration Assistant results differs from SQL Server Profiler RRS feed

  • Question

  • Hi, we are going from SQL server 2012 to 2017.
    Need to know if there are deprecated functions, so used  Microsoft® Data Migration Assistant.
    A great tool and gave me a nice report. Also let SQL Server Profiler run a trace file for deprecated events. Less results of course..but a function (like SETUSER) that Migration Assistant did not mention in it's report. How come ? regards


    • Edited by RobDaWild Thursday, February 20, 2020 11:04 AM
    Thursday, February 20, 2020 11:02 AM

Answers

  • Hi, we are going from SQL server 2012 to 2017.
    Need to know if there are deprecated functions, so used  Microsoft® Data Migration Assistant.
    A great tool and gave me a nice report. Also let SQL Server Profiler run a trace file for deprecated events. Less results of course..but a function (like SETUSER) that Migration Assistant did not mention in it's report. How come ? regards


    Hi Rob,

    If you read the DMA online doc it is mentioned

    Partially supported or unsupported features: Detects partially supported or unsupported features that are currently in use on the source SQL Server instance. DMA provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that you can incorporate them into your migration projects.

    You might have to rely both on Profiler and DMA. Also query shared by Yuxi can be helpful


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Marked as answer by RobDaWild Friday, July 3, 2020 12:34 PM
    Tuesday, February 25, 2020 8:42 AM

All replies

  • Hi RobDaWild,

    Please execute the code as next:

    SELECT * FROM sys.dm_os_performance_counters   
    WHERE object_name = 'SQLServer:Deprecated Features'; 

    You can also reference this: deprecated-database-engine-features-in-sql-server-2017

    Best Regards.

    yuxi



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, February 21, 2020 7:34 AM
  • Hi RobDaWild,

    Is the code useful for you?

    lease remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, February 25, 2020 8:38 AM
  • Hi, we are going from SQL server 2012 to 2017.
    Need to know if there are deprecated functions, so used  Microsoft® Data Migration Assistant.
    A great tool and gave me a nice report. Also let SQL Server Profiler run a trace file for deprecated events. Less results of course..but a function (like SETUSER) that Migration Assistant did not mention in it's report. How come ? regards


    Hi Rob,

    If you read the DMA online doc it is mentioned

    Partially supported or unsupported features: Detects partially supported or unsupported features that are currently in use on the source SQL Server instance. DMA provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that you can incorporate them into your migration projects.

    You might have to rely both on Profiler and DMA. Also query shared by Yuxi can be helpful


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Marked as answer by RobDaWild Friday, July 3, 2020 12:34 PM
    Tuesday, February 25, 2020 8:42 AM
  • Thank you ! will try it, greetings
    Friday, July 3, 2020 12:32 PM
  • Thank you,

    so,  partially supported.

    Greetings

    Friday, July 3, 2020 12:34 PM