Sudo zypper install -oldpackage mssql-server= In the following commands, replace with the SQL Server version number you identified in step one. For a list of package numbers, see the Release notes.ĭowngrade to a previous version of SQL Server. Identify the version number for the SQL Server package you want to downgrade to. To rollback or downgrade SQL Server to a previous release, use the following steps: This is only possible if the upgrade path is supported between the two repositories. Then use the same update command to upgrade your version of SQL Server. To upgrade SQL Server, first change your configured repository to the desired version of SQL Server. The user generated databases and system databases are not affected by this operation.
These commands download the newest package and replace the binaries located under /opt/mssql/. To update the mssql-server package to the latest release, use one of the following commands based on your platform: Platform For more information, see Performance best practices and configuration guidelines for SQL Server on Linux. For more information, see Provision a SQL VM in Azure.Īfter installing, consider making additional configuration changes for optimal performance. You can also run SQL Server on Linux in an Azure virtual machine. For step-by-step instructions, see one of the following quickstarts: Platform You can install SQL Server on Linux from the command line. For more information on repositories and how to configure them, see Configure repositories for SQL Server on Linux. The quickstarts use the Cumulative Update CU repository for SQL Server. When you install or upgrade SQL Server, you get the latest version of SQL Server from your configured Microsoft repository. Ensure that NFS clients use the 'nolock' option when mounting the remote share.Other files, such as the SQL Server system binaries, are not supported. Locate only the /var/opt/mssql directories on the NFS mount.Older versions of NFS do not support required features, such as fallocate and sparse file creation, common to modern file systems. If you use Network File System (NFS) remote shares in production, note the following support requirements: XFS or EXT4 (other file systems, such as BTRFS, are not supported) SQL Server has the following system requirements for Linux: If you choose to install SQL Server on an unsupported operating system, please review the Support policy section of the Technical support policy for Microsoft SQL Server to understand the support implications. SQL Server is tested and supported on Linux for the previously listed distributions.
0 kommentar(er)
