none
Static code analysis function in Visual studio RRS feed

All replies

  • https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Monday, March 23, 2020 5:51 AM
  • amm.. SSMA seems a different things

    I am looking for source is also mssql server

    Tuesday, March 24, 2020 1:29 AM
  • Hi  sakurai_db,

    >Can it detect any code which won't run / or will throw error once the code from the database is going to migrate to later sql version . ?

    If you don’t run the code, it won’t show the error.However you can set Transact-SQL and query processing behaviors to be compatible with the specified version of the SQL engine. And new Transact-SQL syntax is not gated by database compatibility level, except when they can break existing applications by creating a conflict with user Transact-SQL code. These exceptions are documented in the sections of this article that outline the differences between specific compatibility levels.

    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, March 24, 2020 2:50 AM
  • Hi sakurai_db,

    Is the reply helpful?

    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

    Wednesday, March 25, 2020 8:00 AM
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver15

    yes, that's why we need some code scan to scan the static code (like storeproc) , to check which code will hit the error. like the following example of change ?

    Wednesday, March 25, 2020 9:50 AM
  • Hi sakurai_db,

    So what is your issue now?

    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

    Thursday, March 26, 2020 1:41 AM
  • issue is to find a tool to find any TSQL code breaking changes after upgrade to different sql version
    Saturday, March 28, 2020 8:16 AM
  • Saturday, March 28, 2020 9:44 AM
  • Hi  sakurai_db,

    This testing-code-changes-sql-server-upgrade may be helpful.

    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

    Monday, March 30, 2020 5:29 AM