As an additional step, you can add this folder as part of the $PATH environment variable, but I will skip that part for now.
Both command-line utilities will be installed under this path: /opt/mssql-tools/bin/. Once the installation is complete, we have sqlcmd and bcp ready to use. Now that we have the repository ready, we have to update the source list and then proceed with the installation of the mussel-tools package as follows: $ apt-get update The first step is to register the public repository key used by apt to authenticate the packages, then we just simply register Microsoft's official repository for Ubuntu, here are the commands: $ curl | sudo apt-key add. I will be using Ubuntu for this article, this is very important to note because the installation steps are a little bit different if you want to use RedHat. We have to install mssql-tools separately. The mssql-tools package comes installed by default when using a Docker container image of SQL Server, unfortunately, this is not what happens when SQL Server is manually installed on a Linux VM or bare metal machine. Luckily for us, the BCP ( Bulk Copy Program) utility is available for Linux as part of the command line tools package called mssql-tools. To make things complex, one of your clients is asking you to export/import data from/into a SQL Server instance running on Linux (VM or container).
Now, let's take a step back and imagine you have no access to any of these GUI based tools for a moment.
IMPORTING BPC FILES INTO MODO 801 HOW TO
If you are interested to learn how to use Azure Data Studio, I recommend you look at my previous article. We have SSMS, Azure Data Studio, Visual Studio (SSDT), SSIS, Toad for SQL Server, RapidSQL to name a few.
Moreover if you like GUI based tools, there are plenty of options. Loading smalls set of data into SQL Server has been always easy on Windows.