Regarding SQL Automation upgrade issues

Sai

Hi Team,

I m using VS2017, I have old version ReadyRoll Projects in my solution, Lets say ReadyRollProjA and ReadyRollProjB.

Today, I have downloaded SQL Automation Tool version  3.0.18262.1427, I have create new SQL Automation Projects Lets Say ReadyRollProjC and ReadyRollProjD.

When Im trying to refresh the projects ReadyRollProjC and ReadyRollProjD, they are working absolutely fine.

But when im trying to refresh the projects ReadyRollProjA and ReadyRollProjB, They are giving me the error

Error :

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Done building project "ReadyRollA.sqlproj" -- FAILED.Please find the Log Detail from TFS Checkin :2018-09-24T19:03:32.9236244Z "F:\Build\Agent2\_work\6\s\ProspectiveMaster.sln" (Build target) (1) ->
2018-09-24T19:03:32.9236244Z "F:\Build\Agent2\_work\6\s\DB\GlobalDB.SQLAutomation\GlobalDB.SQLAutomation.sqlproj" (default target) (47) ->
2018-09-24T19:03:32.9236244Z   F:\Build\Agent2\_work\6\s\DB\GlobalDB.SQLAutomation\GlobalDB.SQLAutomation.sqlproj(167,68): error MSB4226: The imported project "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\SqlChangeAutomation\SqlChangeAutomation.Data.Schema.Ssdt.targets" was not found. Also, tried to find "SqlChangeAutomation\SqlChangeAutomation.Data.Schema.Ssdt.targets" in the fallback search path(s) for $(MSBuildExtensionsPath) - "C:\Program Files (x86)\MSBuild" . These search paths are defined in "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\amd64\MSBuild.exe.Config". Confirm that the path in the <Import> declaration is correct, and that the file exists on disk in one of the search paths.
2018-09-24T19:03:32.9236244Z
2018-09-24T19:03:32.9236244Z
2018-09-24T19:03:32.9236244Z "F:\Build\Agent2\_work\6\s\ProspectiveMaster.sln" (Build target) (1) ->
2018-09-24T19:03:32.9236244Z "F:\Build\Agent2\_work\6\s\DB\MasterDB.SQLAutomation\MasterDB.SQLAutomation.sqlproj" (default target) (48) ->
2018-09-24T19:03:32.9236244Z   F:\Build\Agent2\_work\6\s\DB\MasterDB.SQLAutomation\MasterDB.SQLAutomation.sqlproj(183,68): error MSB4226: The imported project "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\SqlChangeAutomation\SqlChangeAutomation.Data.Schema.Ssdt.targets" was not found. Also, tried to find "SqlChangeAutomation\SqlChangeAutomation.Data.Schema.Ssdt.targets" in the fallback search path(s) for $(MSBuildExtensionsPath) - "C:\Program Files (x86)\MSBuild" . These search paths are defined in "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\amd64\MSBuild.exe.Config". Confirm that the path in the <Import> declaration is correct, and that the file exists on disk in one of the search paths.
2018-09-24T19:03:32.9236244Z

PeterG

Hi Sai,

The error message you describe looks different from the logs you included.

From what I can see ReadyRollA is failing to build due to a login connection issue. For help with that I would recommend emailing support@red-gate.com.

As for the other two projects GlobalDB.SQLAutomation and MasterDB.SQLAutomation are failing to due to the build agent not being upgraded. From those logs it looks like you need to upgrade from ReadyRoll to Sql Change Automation on your build agents.