The Type Or Namespace Name 'management' Does Not Exist In The Namespace 'microsoft.sqlserver' - Sqlparser And Vsts Automated Builds

I am using the Parser that is part of Microsoft.SqlServer.Management.SqlParser.Parser namespace in order to parse a Sql statement and it works fine when testing, however; the build

Solution 1:

If you are targeting SQL server 2017, then you will need to include the SMO NuGet package in your project.

Otherwise you will need to install the SharedManagementObjects.msi from the Feature Pack of the SQL server version and service pack level you are targeting or referencing.

SQL Server 2016 SP2 Feature PackSQL Server 2014 SP2 Feature PackSQL Server 2012 SP4 Feature Pack