SQL Server on Linux tools: mssql-cli and mssql-scripter
To enable you to choose the best platform for your data and applications, SQL Server is bringing its world-class RDBMS to open source enterprise ecosystems with SQL Server on Linux.
Learn about recent developments and get answers to your questions at twice-monthly virtual town halls, where Microsoft connects you with the team behind SQL Server on Linux. Each session will begin with a new topic, but all questions about SQL on Linux are welcome.
Since the announcement that SQL Server 2017 supports Linux and Docker, there became a need for modern, cross-platform CLI tools that give DBA's and developers the flexibility of using SQL Server anywhere.
Our team has chosen to collaborate with the open source community to create two great Python-based tools: mssql-cli and mssql-scripter.
- mssql-cli is an interactive T-SQL query tool which includes features such as auto-completion, syntax highlighting, and pretty formatting. To create this tool, we collaborated with the dbcli community which includes other CLI tools such as pgcli and mycli.
- mssql-scripter is a scripting tool for SQL Server databases and can easily generate CREATE and INSERT t-sql scripts for database objects like pg_dump and mysqldump.