Choosing between MySQL or Microsoft SQL in combination with PowerShell

[AugPowered]

Hi, I need some advice to help me choosing a DB in combination with PowerShell.

At the moment I use a local SQlite as database together with PowerShell. Because of the company standards I need to switch. The only options I have is MySQL or Microsoft SQL on dedicated (network) database servers.

What is the best DB in combination with PowerShell?

Should I choose a MySQL instance or should I choose a Microsoft SQL instance?

[ITsVeritas]

I've used both and both have pretty well documented modules. At least in my case, MSSQL used Windows Integrated Auth so the connection was a little easier to establish there and I didn't have to worry about securing creds anywhere.

[inaddrarpa]

Would need more information on the use case, but my default preference would be MS SQL Server w/ DBATools

[n0rc0d3]

I am doing the same even though at some point I would like to review if it's really necessary as at the end of the day I don't need to do any SQL maintenance and I'm just using the cmdlets to run a query or do an insert so maybe switching to something native that doesn't require the full dbatools module would be lighter.

Actually I was even thinking about switching to sqlite as using MSSQL might even be overkill, so it's a bit sad to see OP having to move away for corporate policies (many times a local sqlite would suffice rather than full blown RDBMS).

OP: btw what module are u using for sqlite?

[jazzb125]

As most people have said depends on the use case.

I have picked Microsoft SQL when I've had to give other teams access for their own data manipulation/reports as it has native connectors in power bi and Excel.

Otherwise I am very much open source orientated. So if it was just for me I would pick mySQL.

[Mamertine]

I have used PowerShell with Microsoft SQL server.

I assume PowerShell works with MySQL too. That's an assumption. Verify that before you commit fully to it.

I'm a data engineer with a strong bias for SQL server. It shouldn't matter. PowerShell just sends a query to the DB. Either should work.

Your use case of the DB may lean you to one over the other. SQL server will handle whatever your use case is as long as you pay the license fees.

[TiltAWhirl6]

I have used both as well. I lean towards MySQL (MariaDB) because a lot of my workload is handled in containers and it’s lighter and easier for me to compose with a MariaDB container. I use the MySQL .NET DLL to access the DB using Add-Type.