search

Teutenberg / DBAid2

SQL Server administrative support database
MIT License
1 stars 1 forks source link

Require version of DBAid to work with SQL Server on Linux #4

Open thecosmictrickster opened 5 years ago

thecosmictrickster commented 5 years ago

With SQL Server being on Linux now, we need a version of DBAid that can be deployed. One of the main considerations is working around the lack of CmdExec subsystem in SQL Agent.

Teutenberg commented 5 years ago

We will need to make sure our PS scripts are compatible with PowerShell Core, https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell-core-on-linux?view=powershell-6

thecosmictrickster commented 5 years ago

I haven't been able to get Invoke-Sqlcmd to behave properly under CentOS. It doesn't seem to like the -ServerInstance parameter (if it's omitted, it will connect to the default instance; I don't have a named instance yet to experiment further).

While nosying around, I found a comment from Feb 2019 that the Invoke-* cmdlets under the sqlserver module doesn't work in PowerShell Core (https://stackoverflow.com/questions/52210823/invoke-sqlcmd-cmlet-missing-in-powershell-core-sqlserver-module-for-linux). Uh oh.

thecosmictrickster commented 5 years ago

OK, looks like multiple instances aren't supported on Linux per se. It's recommended to use Docker containers. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-2017#run-multiple-sql-server-containers

Teutenberg commented 5 years ago

Might need to use SQL client package for data access:

https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/

On Tue, 25 Jun 2019, 3:39 PM thecosmictrickster, notifications@github.com wrote:

OK, looks like multiple instances aren't supported on Linux per se. It's recommended to use Docker containers. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-2017#run-multiple-sql-server-containers

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Teutenberg/DBAid2/issues/4?email_source=notifications&email_token=AB5JH53GXLCBZGZ6JYDNCLTP4GHN5A5CNFSM4H2Z32BKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYO4U3Q#issuecomment-505268846, or mute the thread https://github.com/notifications/unsubscribe-auth/AB5JH54HI6JQPN2BWVNGX4DP4GHN5ANCNFSM4H2Z32BA .