Installing the sqlpackage client utility

Note:

The sqlpackage client utility recommended version is 19.2 (Build: 162.0.52).

Download locations	https://docs.microsoft.com/en-us/sql/tools//sqlpackage-download?view=sql-server-ver15
	https://packages.microsoft.com/rhel/7/prod/msodbcsql17-17.9.1.1-1.x86_64.rpm
	https://packages.microsoft.com/rhel/7/prod/unixODBC-2.3.7-1.rh.x86_64.rpm

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 the sqlpackage is added as a default path variable. If you still get the: Cannot find sqlpackage error, restart the NetBackup services on the media server.
sqlpackage
rpm -ivh unixODBC-2.3.7-1.rh.x86_64.rpm
rpm -ivh msodbcsql17-17.10.2.1-1.x86_64.rpm

RHEL 9 users perform the following additional steps:

Download the Microsoft.NETCore.App.Runtime.linux-x64 from the link:
https://www.nuget.org/api/v2/package/Microsoft.NETCore.App.Runtime.linux-x64/6.0.10
Locate the file: microsoft.netcore.app.runtime.linux-x64.6.0.10.nupkg.
Extract the file using a decompression tool like, 7zip.
Navigate to:
microsoft.netcore.app.runtime.linux-x64.6.0.10.nupkg\runtimes\linux-x64\lib\net6.0\
Copy the file System.Security.Cryptography.X509Certificates.dll from there to the ~/sqlpackage folder created in step 2 of installing the sqlpackage client utility task.

If you are attaching the 10.1 media server as an external media server with 10.1.1 NetBackup setup, perform the following steps on the 10.1 media server.

For a BYO NetBackup setup:

Run the command:
mkdir -p <backup and restore ushare export path>
Check the Defaultvers value of NFS in the /etc/nfsmount.conf file.
- If the Defaultvers value is nfs3, then mount the backup and restore ushare path with the option nolock. For example: mount <ushare mount path> <ushare export path> -o nolock
- If the Defaultvers is nfs4, mount the backup and restore ushare path without the nolock option.

For NetBackup deployed in AKS and EKS environments:

Run the command:
mkdir -p <backup and restore ushare export path>
Check the Defaultvers value of NFS from the /etc/nfsmount.conf file.
- If the Defaultvers value is nfs3, then mount the backup and restore ushare path with the option nolock For example: mount <ushare mount path> <ushare export path> -o nolock
- If the Defaultvers value is nfs4, then mount the v4 version of backup and restore ushare path without the nolock option.

Installing the sqlpackage client utility

Feedback

Feedback