Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Count not load schema model from package. (Microsoft.SqlServer.Dac)

Tags:

sql

sql-server

azure-sql-database

azure

bacpac

enter image description here> ADDITIONAL INFORMATION:

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 ?

like image 273
Jaimin Soni Avatar asked Nov 29 '17 07:11

Jaimin Soni

People also ask

How to unpack Microsoft SQL Server DAC package file?

Unpack Microsoft SQL Server DAC Package File. Use this page to specify the destination folder in which to place the unpacked files, and then run the unpack operation. Files will be unpacked to this folder: - Specify the full path to the folder for the unpacked files. If the folder exists and you know the full path, type the path in the box.

Why can't I import a V12 database into SQL 2012?

If you have a v12 database, and you export it to a BACPAC, you could run into the above error if you are importing it into a lower version of SQL. In my case, I was able to get the error when I tried to import it into SQL 2012 using the Management Studio for SQL 2012. The issue here is the version of the Client Tools.

How do I deploy a DAC from an unknown source?

Before you use a DAC from an unknown or untrusted source, deploy it on an isolated test instance of the Database Engine, unpack the DAC and examine the code, such as stored procedures or other user-defined code. In Windows Explorer, navigate to the location of a DAC package (.dacpac) file.

How can I compare the contents of a DAC?

The contents of one DAC can also be compared with the contents of another package unpacked to another folder. To unpack a DAC, using: Unpack Data-tier Application Dialog, Examine the Contents of a DAC Package We recommend that you do not deploy a DAC package from unknown or untrusted sources.

1 Answers

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

  • Replace the upper-cases with your SERVER/DB info.
  • Use correct folder (110,120,130,140...)
like image 175
AlonMichaeli Avatar answered Sep 30 '22 12:09

AlonMichaeli
Sign in to Comment

Related questions

Keeping connection alive - mysql
find unique minimum and maximum dates from 4 tables - php
SQL select every xth row based on total number
PostgreSQL - Right Index choice for a status field (varchar)
Postgres bulk INSERT function using JSON arguments
Statement on different SQL Server with different languages
Jooq how to query entity based on composite key
Difference between SQL LIKE without percent signs and equal (=) in WHERE clause
How to use IN clause with multiple columns on same data in postgresql?
Performance impact of using GUID in SQL Server
How to Get the Shorthest Path in a Flightroutes-Table
Using pg_restore to create or overwrite tables
How to copy table by spark-sql
SQL autoformatting in codeMirror
SQL tag list and tag filtering
Cannot resolve the collation conflict between "Latin1_General_BIN" and "Latin1_General_CI_AS" in the equal to operation
How to retrieve null lookup entries on mongodb?
Can Entity Framework (LINQ) select rows based on JSON where clause?
SQL - Using COUNT() as a WHERE condition
SELECT VALUES in Teradata

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!