Installing sqlpackage client utility
To install, run the following commands in the terminal:
- cd ~
- mkdir sqlpackage
- unzip ~/Downloads/sqlpackage-linux-<version string>.zip -d ~/sqlpackage
- echo "export PATH=\"\$PATH:$HOME/sqlpackage\"">> ~/.bashrc
- chmod a+x ~/sqlpackage/sqlpackage
- source ~/.bashrc
Note:
Ensure that
sqlpackageis added as a default path variable. - sqlpackage
- rpm -ivh unixODBC-2.3.7-1.rh.x86_64.rpm
- rpm -ivh msodbcsql17-17.9.1.1-1.x86_64.rpm
- Copy these libraries to
/usr/openv/lib/libodbc.so.2.0.0, libodbc.so.2, libodbc.sofrom/usr/lib64libmsodbcsql-17.9.so.1.1from/opt/microsoft/msodbcsql17/lib64/