Shulou(Shulou.com)06/01 Report--

Upgrade mssql-server package to the latest version of sudo yum update mssql-server

This command downloads the latest package and replaces the binaries under / opt/mssql/. User-generated and system databases are not affected by this operation.

Roll back SQL Server to a previous version

1. Identify the SQL Server version number you want to downgrade to. For a list of corresponding version numbers, see here.

two。 Downgrade to a previous version of SQL Server. Will be replaced with the version number in step 1.

Sudo yum downgrade mssql-server-.x86_64

Note: downgrading to only one version within the same major version, such as SQL Server 2017, is supported.

Check the installed version of SQL Server

To verify the version of SQL Server currently running on Linux, use the following procedure:

1. Install the SQL Server command line tool.

two。 Run the following command:

Sqlcmd-S localhost-U SA-Q 'select @ @ VERSION'

Uninstall SQL Server

To remove the mssql-server package running on Linux, use the following command:

Sudo yum remove mssql-server

Removing the package does not delete the generated database file. If you want to delete the database file, you can use the following command:

Sudo rm-rf / var/opt/mssql/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.