Using Sql server utilities

Follow these steps to install the SQL Server:

  1. Download the Microsoft Red Hat repository configuration file.

    sudo curl > /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.

  6. Restart the DataFlow service.

    #tscli --adv service restart dataflow