In Chapter 2, Installation and Configuration, we covered the installation procedure of SQL Server database engine and command-line tools. In this phase of development (CTP 1.3 - RC1) there is a limited number of tools to interact with SQL Server. But that will be changed in the near future. If this book was about the Windows platform, then content would likely be different, but this does not mean that we don't have quality tools to work with this database engine.
Here is a list of the most used currently supported tools on Linux and Windows platforms:
- sqlcmd (Linux)
- bpc (Linux)
- Visual Studio Code (Linux)
- SSMS (Windows)
The command-line utility, sqlcmd, offers batch execution of T-SQL scripts and a simple utility for executing T-SQL statements. It will be our primary interaction interface with SQL Server database engine. If you want to connect to your SQL Server instance you will need to type sqlcmd
and the following parameters: (-S server name, -U user name...