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.”