如何获取在MS-SQL 2008(661版本)上运行的SQL数据库的模式和数据? [英] How can I get the schema and data of an SQL db running on MS-SQL 2008 (661 version)?
本文介绍了如何获取在MS-SQL 2008(661版本)上运行的SQL数据库的模式和数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
I am trying to attach a db of MS-SQL 2008 (version 661) to my MS-SQL Server but every time it is displaying message of version mismatch. My MS-SQL 2008 version is 655.
Do I have any alternative for this solution?
Please suggest.
Thanks
IB
我的尝试:
我试过在谷歌上找到它但无法得到一个可以解决我的问题的满意答案。
What I have tried:
I have tried finding it on google but could not get a satisfactory answer which can resolve my problem.
推荐答案
您正在尝试将SQL Server 2008 R2数据库附加/还原到SQL Server 2008实例。这是不支持的。
您有两种选择:
You are trying to attach / restore a SQL Server 2008 R2 database to a SQL Server 2008 instance. This is not supported.
You have two options:
- 将SQL Server 2008实例升级到SQL Server 2008 R2。
根据您的版本,这很可能需要花钱。 - 生成脚本以重新创建数据库结构,从2008 R2实例导出数据,然后将其导入2008实例。
例如:如何将SQL Server数据库迁移到较低版本 [ ^ ]
- Upgrade your SQL Server 2008 instance to SQL Server 2008 R2.
Depending on which edition you have, this will most likely cost money. - Generate scripts to recreate your database structure, export the data from the 2008 R2 instance, and import it into the 2008 instance.
For example: How to migrate a SQL Server database to a lower version[^]
这篇关于如何获取在MS-SQL 2008(661版本)上运行的SQL数据库的模式和数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文