In SQL Server 2000, you have the "All Tasks... - Export Data" option. Where is this option the SQL Server 2005 Management Studio?
在SQL Server 2000中,您具有“所有任务... - 导出数据”选项。这个选项在哪里SQL Server 2005 Management Studio?
Or, is there a SQL Server 2005 way of doing this?
或者,是否有SQL Server 2005这样做的方式?
EDIT: I am using the Express edition.
编辑:我正在使用Express版。
EDIT: Joel's response answers my question but Mike's answer gives a great alternative to those of us using the Express edition (vote him up!!).
编辑:乔尔的回答回答了我的问题,但迈克的答案给了我们这些使用Express版本的人一个很好的选择(投票给他!!)。
5 个解决方案
#1
2
If you're using the express edition of management studio the Import and Export features aren't available.
如果您使用的是管理工作室的快速版,则无法使用导入和导出功能。
#2
3
You could use the excellent SQL Server Database Publishing Wizard.
您可以使用优秀的SQL Server数据库发布向导。
It allows you to generate a script which contains data, schema, or both. The script can be targeted towards SQL 2000 or SQL 2005.
它允许您生成包含数据,架构或两者的脚本。该脚本可以针对SQL 2000或SQL 2005。
Some use it for web hosting environments. I use it to move data when I have no other option.
有些人将它用于网络托管环境。当我没有其他选择时,我用它来移动数据。
#3
1
DTS has been replaced by SSIS on the business intelligence end of things.
DTS已被商业智能终端上的SSIS所取代。
#4
1
Probably easiest to just do a backup in SQL 2000 and then import the backup into SQL 2005 using the restore. Those options are available in the Express Edition.
可能最简单的方法是在SQL 2000中进行备份,然后使用还原将备份导入SQL 2005。 Express Edition中提供了这些选项。
#5
0
There is always the BCP option.
总有BCP选项。
#1
2
If you're using the express edition of management studio the Import and Export features aren't available.
如果您使用的是管理工作室的快速版,则无法使用导入和导出功能。
#2
3
You could use the excellent SQL Server Database Publishing Wizard.
您可以使用优秀的SQL Server数据库发布向导。
It allows you to generate a script which contains data, schema, or both. The script can be targeted towards SQL 2000 or SQL 2005.
它允许您生成包含数据,架构或两者的脚本。该脚本可以针对SQL 2000或SQL 2005。
Some use it for web hosting environments. I use it to move data when I have no other option.
有些人将它用于网络托管环境。当我没有其他选择时,我用它来移动数据。
#3
1
DTS has been replaced by SSIS on the business intelligence end of things.
DTS已被商业智能终端上的SSIS所取代。
#4
1
Probably easiest to just do a backup in SQL 2000 and then import the backup into SQL 2005 using the restore. Those options are available in the Express Edition.
可能最简单的方法是在SQL 2000中进行备份,然后使用还原将备份导入SQL 2005。 Express Edition中提供了这些选项。
#5
0
There is always the BCP option.
总有BCP选项。