Google Cloud Launches In-Place Major Version Upgrades for Cloud SQL for SQL Server

Google Cloud has announced the availability of in-place major version upgrades for Cloud SQL for SQL Server, supporting transitions from versions 2017 and 2019 to SQL Server 2022. This new capability eliminates the need for manual data migration between separate instances, significantly reducing the operational overhead and risk associated with legacy upgrade paths. By utilizing this feature, administrators can maintain their existing instance configurations, including IP addresses and connection strings, which simplifies the overall application update lifecycle. The technical workflow involves an automated process that includes pre-upgrade compatibility checks and immediate engine binary updates. When an upgrade is initiated via the Google Cloud Console or CLI, the system automatically creates a safety backup before applying the new version. Although a brief period of downtime is required during the binary swap, the elimination of manual export and import steps makes the process faster and less prone to human error compared to traditional methods. Post-upgrade, users can choose to update the database compatibility level to leverage SQL Server 2022 specific features such as Intelligent Query Processing. This provides a clear path for database modernization, allowing teams to test performance impact before fully committing to the latest query optimizer behaviors. The feature also supports multi-step upgrades for older versions like SQL Server 2012, providing a robust toolset for enterprises looking to stay current with Microsoft's database lifecycle support.