sql-server


importing SQL Server .bacpac file


I've been trying (and failing) to import a SQL .bacpac file to SQL 2014 Express. Does anyone know if it's even possible to import these to Express? I haven't found anything online saying otherwise, but thinking of just getting the developer edition to try that instead. For info here is the error I get
Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider 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)
thanks
The '130' database level is SQL 2016, but you are attempting to restore it to a SQL 2014 database. SQL Server backups have never been backward compatible.
This did not work because the version of SqlPackage.exe, SSMS or the Data-Tier Application Framework that you're using to import the bacpac file to your server is too old and therefore doesn't know about SQL Server 2016. If you install the latest version of SSMS (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms) you should be able to import that bacpac file.
However -- do note that if your bacpac file contains any object that isn't supported in SQL Server 2014 (for example, a temporal table), then the import operation will fail.

Related Links

JDBC can't connect - SQL
xp_cmdshell Proxy not Executing
Get a username from email ID
VBA INSERT and ##Identity (can't get ##Identity on a 2nd insert into a new table)
Can I filter the results from an OUTPUT clause without storing it in a table?
SQL Server/Oracle calling specifix Index [closed]
How to know most used procedure in my database?
How to use a CTE statement in a table-valued function in SQL Server
How to use while loop with string joinnig with plus?
Why does performance degrade when using a non-indexed field in the SELECT clause?
Multi Column to One Column
SQLServer object_id for indices?
Issue with fluent nhibernate TriggerIdentity in SQL Server?
Adding Customer Specific Record in Master Table
Finding string in given set of strings bt comma separated
How to load data from a single CSV file into multiple tables with relations? [duplicate]

Categories

HOME
visual-studio-2015
cil
symfony
system-verilog
wildcard
vs-team-services
json-ld
reportportal
mainframe
devstack
slim-3
metronic
abcpdf
cs-cart
x-frame-options
ida
ng-show
flat-file
jive
koa
marathon
python-textprocessing
ivy
encase
consumer
exponential
service-locator
powershell-remoting
geomesa
pace
swagger-editor
initializer
cross-entropy
wcf-security
socketscan
g1gc
upsert
bids
xmgrace
struts-layout
mbaas
crash-reports
forerunnerdb
modelattribute
tofixed
gce
python-hypothesis
visual-studio-templates
festival
spark-cassandra-connector
com-interop
image-editing
distribute
flexjson
git-rebase
galaxy
servlet-3.0
android-viewholder
selendroid
textkit
ibm-data-studio
epl
hiera
chaining
fragment-tab-host
hidden-field
aquafold
codeigniter-a3m
indexing-service
bounds
anjuta
xenocode
db4o
sim900
logentries
document-database
dwolla
process-monitor
pys60
git-filter-branch
moq-3
continuous-testing
die
visual-web-gui
point-sprites
easygui
qtembedded
rubycas
symbol-server
pureftpd
surefire
linfu
rtsp-client
callgrind
web-analytics-tools

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App