Sample Header Ad - 728x90

Find SQL version of Azure server

3 votes
0 answers
502 views
I have been restoring bacpacs provided by a third party on my on prem sql server via powershell. I copy over the bacpac from an SFTP site on to my local drive. This time I have been getting errors which lead me to believe that the bacpac has been created on a higher version of sql . My on prem version is- **Microsoft SQL Server 2019 (RTM-GDR) (KB5014356) - 15.0.2095.3 (X64) Apr 29 2022 18:00:13 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)** On enquiring with the third party they told me that the bacpac has been created on- **Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 16 2022 04:43:19 Copyright (C) 2022 Microsoft Corporation.** How can i compare the 2 to find if the Azure version is higher ?
Asked by mail_sady (51 rep)
Feb 3, 2023, 09:55 AM
Last activity: Feb 3, 2023, 10:58 AM