[Quick Blog] SQL Server Cross-Platform Command Line Tools

Recently while I was on a conference call with some of the engineers from the SQL Server product team at Microsoft, the topic of their new multi-platform scripting tool came up. I told them that I would really prefer to use PowerShell to script out my database objects no matter which O/S I was using or the database was hosted on.

I also mentioned that the tools can be kind of hard to find. With that in mind, I just wanted to write this quick blog post in the hopes of making it easier for customers to find these tools so they can try them out.

Here’s an excerpt from their GitHub page for mssql-scripter:

“We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.

mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse.”

Cheers!

Please Share This:

Share on facebook
Share on twitter
Share on linkedin

You may also like:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow:

Subcribe to Blog Via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

What I'm Saying on Twitter

Subscribe via feedburner