Sandor

Only sometimes? We could use a bit more logs and details to look at what is going on.

@asiffermann I'd be happy to have your feedback on the recent changes I've made on that matter before I publish it :)

Actually, we may want to move SQLServer/SQLPS and sqlpackage install to some tool installer task.

They have [changed](https://blogs.msdn.microsoft.com/ssdt/2016/06/30/changes-to-ssdt-and-sqlpackage-exe-installation-and-updates/) the nuget package for sqlpackage which is now there https://www.nuget.org/packages/Microsoft.SqlServer.DacFx.x64/ I was running into that problem : https://blogs.msdn.microsoft.com/azuresqldbsupport/2017/09/19/deployment-fails-with-unable-to-connect-to-master-or-target-server-mydb_svr-you-must-have-a-user-with-the-same-password-in-master-or-target-server-mydb-db/ And it seems the probleme is related to azure...

Arf no DacFx does not contain the exe. and https://www.nuget.org/packages/Microsoft.Data.Tools.Msbuild/ mentioned here https://blogs.msdn.microsoft.com/ssdt/2016/08/22/releasing-ssdt-with-visual-studio-15-preview-4-and-introducing-ssdt-msbuild-nuget-package/ lags one version behind

Currently the detection script picks an older version that the last one available (which should be 140 instead of 130): C:\Program Files (x86)\Microsoft SQL Server\140\Dac\bin\SqlPackage.exe ``` 2017-12-12T12:30:38.6794755Z ##[debug]Sql Versions installed...

Oops the log was from our out of date agent which explains a lot. Which is the perfect illustration of the need of a tool installer especially since azure team...

I guess it's a feature request, would you mind elaborating on how you see things. The output can be many things, from scalars to tables. What's your exact expectation there?

Yes a pull request is mire than welcome 🙏 On Sun 9 Dec 2018 at 09:07, Sam Smith wrote: > I second this request. Are you open to pull requests...

Hi @samsmithnz, The task UI is defined in `task.json` https://github.com/geeklearningio/gl-vsts-tasks-azure/blob/master/Tasks/RestoreSqlDatabaseToSqlDatabase/task.json Yes the powershell script should be runable. On one task we started adding pester tests. I could be a great...