Andreas Jordan
Andreas Jordan
I use this script to test both supported versions of Oracle Linux: ``` $ErrorActionPreference = 'Continue' Import-Module -Name AutomatedLab, Posh-SSH, PSFramework $LabName = 'TestLabOL' $LabNetworkBase = '192.168.102' $LabAdminUser = 'User'...
@nyanhp - just updated the CHANGELOG and the initial post. Everything (except Oracle Linux 9) works from my point of view so I will stop here. When I have time...
I totally agree with @niphlod's point. Just one general thought: If we have a command that takes `[DbaInstanceParameter[]]$SqlInstance` - an array of instances - the output should always include the...
Why don't we use the property? https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.management.smo.database.changetrackingenabled?view=sql-smo-172#microsoft-sqlserver-management-smo-database-changetrackingenabled
@ReeceGoding yes, you are right. I was on the wrong track...
Maybe we should wrap `$server.Query("SELECT name, state, SUSER_SNAME(owner_sid) AS [Owner], is_cdc_enabled FROM sys.databases")` with a try catch and use the old query in the catch block.
The code looks save now, thanks fo rthe change. But we need to talk about the values. Should the property IsCdcEnabled be of type boolean? I can not test this...
So `$server.Query("SELECT name, state, SUSER_SNAME(owner_sid) AS [Owner], 0 AS is_cdc_enabled FROM sys.databases")` returns a number, not a boolean. As the feature is not present in that version, I vote for...
Tests show that there are new problems with changing database context. I will try to look at that tomorrow.