将数据库导入客户计算机时出现问题 [英] Problem in importing database to customer computer
问题描述
我正在将我的数据库导出给客户,该客户向我显示以下错误:
无法从包加载架构模型。 (Microsoft.SqlServer.Dac)
附加信息:
内部错误。内部目标平台类型Sql110DatabaseSchemaProvider不支持模式文件版本'2.5'。
我在客户的PC上安装了SQL Server 2012,与创建它的版本相同。
我还在客户的电脑上安装了Crystal Reports。
请帮帮我,提前谢谢。
我尝试了什么:
我正在出口我的数据库给客户,它显示以下错误:
无法从包加载架构模型。 (Microsoft.SqlServer.Dac)
附加信息:
内部错误。内部目标平台类型Sql110DatabaseSchemaProvider不支持模式文件版本'2.5'。
我在客户的PC上安装了SQL Server 2012,与创建它的版本相同。
我还在客户的电脑上安装了Crystal Reports。
请帮帮我,提前谢谢。
有两个简单的选项
一个(复制数据库和附件)
1.将空白数据库文件复制到目的地(Yourdata.mdf,Yourdata_log.ldf)
2.使用SSMS附加空白文件(Management Studio)
两个(生成脚本)
在导出模式时
使用任务选项生成脚本。
时间生成脚本单击高级按钮。
检查以下选项
1.服务器版本脚本 - SQLSERVER 2012(无论哪个)
2 D的类型ata to script - 仅架构/架构和数据(根据选择)
3.附加到文件 - True
4.脚本创建/脚本删除和创建(根据您的选择)
并根据您的需要设置其他选项。
然后生成脚本并使用此脚本创建数据库和Schema
I'm exporting my database to a customer which shows me the following error:
Could not load schema model from package. (Microsoft.SqlServer.Dac)
ADDITIONAL INFORMATION:
Internal Error. The internal target platform type Sql110DatabaseSchemaProvider does not support schema file version '2.5'.
I installed SQL Server 2012 on the customer's PC, the same version in which it is created.
I also installed Crystal Reports on the customer's computer.
Please help me, thanks in advance.
What I have tried:
I'm exporting my database to a customer which shows me the following error:
Could not load schema model from package. (Microsoft.SqlServer.Dac)
ADDITIONAL INFORMATION:
Internal Error. The internal target platform type Sql110DatabaseSchemaProvider does not support schema file version '2.5'.
I installed SQL Server 2012 on the customer's PC, the same version in which it is created.
I also installed Crystal Reports on the customer's computer.
Please help me, thanks in advance.
there are two simple options
One ( Copy Database and Attach)
1. copy Blank database files to destination (Yourdata.mdf , Yourdata_log.ldf )
2. Attach blank file using SSMS ( Management Studio)
Two ( Generate scripts )
At time of export of schema
use tasks options to generate script.
At time of generating script Click Advance button.
Check following options
1. Script for Server Version -- SQLSERVER 2012 ( whichever you want)
2. Type of Data to script -- Schema only / schema and data ( as per choice )
3. Append to file -- True
4. Script Create / Script Drop and Create ( as per choice)
and set other options as per your need.
Then generate script and use this script to create the database and Schema
这篇关于将数据库导入客户计算机时出现问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!