无法将sql 2008数据库数据获取到sql 2005数据库 [英] not getting sql 2008 database data to sql 2005 database

问题描述

我想将sqlserver -2008的数据库数据转换为sqlserver-2005的数据库，请告诉我我已经尝试通过导入导出向导进行的过程，我对此进行了3个小时的尝试，但没有来过，请帮助我

i want to get database data of sqlserver -2008 to sqlserver-2005 database please tell me the process i have tried through import export wizard iam a fresher i worked on it for 3 hours but not coming please help me

推荐答案

要在SQl2005中获得SQL2008数据库，您必须将其导出为脚本，然后尝试在SQL2005中执行脚本-您可能需要手动编辑它才能删除任何内容.早期版本不了解的功能，取决于您使用或未使用的功能.

要将其导出为脚本，请在SQL2008中打开数据库，然后右键单击数据库名称.从上下文菜单中选择任务"，然后选择生成脚本".从那里开始跟随对话框.

To get an SQL2008 database in SQl2005, you will have to export it as a script, and try executing the script in SQL2005 - you may have to edit it by hand to remove any features the earlier version does not understand, it depend on what you have or haven''t used.

To export as a script, open the DB in SQL2008, and right click on the DB name. Select "Tasks" from the context menu, and then "Generate Scripts". Follow the dialogs from there.

这篇关于无法将sql 2008数据库数据获取到sql 2005数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！