Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. (Microsoft.Data.Tools.Schema.Sql)
I am getting above error when I am restoring Azure SQL Bacpac file in local environment. I have below environment on Azure and Local.
Azure SQL RTM Version : Microsoft SQL Azure (RTM) - 12.0.2000.8 Aug 29 2017 13:06:11 Copyright (C) 2017 Microsoft Corporation
Local Environment SQL RTM Version : Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 15063: )
Can anyone please suggest the compatible version of Management studio or SQL RTM for above Azure SQL RTM database restore ?
I haven't managed to solve it through SSMS, the only way that worked was through CMD: "C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe" /a:Import /sf:PATH-TO-BACPAC-FILE /tsn:SERVER-NAME /tdn:DATABASE-NAME /tu:USER-NAME /tp:PASSWORD