Using Sql server utilities

Follow these steps to install the SQL Server:

  1. Download the Microsoft Red Hat repository configuration file.

    sudo curl https://packages.microsoft.com/config/rhel/8/prod.repo > /etc/yum.repos.d/msprod.repo

  2. If you have previous version of mssql-tools installed, remove any older unixODBC packages.

    sudo yum remove mssql-tools unixODBC-utf16-devel

  3. Run the following commands to install mssql-tools with the unixODBC developer package.

    sudo yum install mssql-tools unixODBC-devel

  4. Add bcp/sqlcmd command in dataflow, then it creates symlinks in /usr/bin folder.

     sudo ln -s /opt/mssql-tools/bin/bcp /usr/bin/bcp
 sudo ln -s /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd

  5. Verify the installation by running the bcp or sqlcmd command.

    #sqlcmd

  6. Restart the DataFlow service.

    #tscli --adv service restart dataflow
Was this page helpful?
×