In SQL Server 2000 you had DTS where you had the option to choose to export table structure along with data and also to choose specific tables only. Is there a similar option in SQé Server 2005 version.
在SQL Server 2000中，有DTS选项，可以选择导出表结构和数据，也可以只选择特定的表。在SQe Server 2005版本中有类似的选项吗?
I would like to export just 5 tables along structure and data from an existing database to another database. The data is required as it contains auto increment id fields that are maintained as foreign keys.
我想从现有数据库到另一个数据库的结构和数据中只导出5个表。数据是必需的，因为它包含作为外键进行维护的自动递增id字段。
3 个解决方案
#1
0
SSMS has a facility to do this available from the object explorer (somewhat counter-intuitively this is not available within BIDS). This invokes a wizard that generates an SSIS package that can export one or more tables to another database.
SSMS有一个工具可以从object explorer(有点反直觉的是，这在投标中是不可用的)实现这一点。这将调用一个向导，该向导生成一个SSIS包，该包可以将一个或多个表导出到另一个数据库。
Right click on the node in the SSMS object explorer, select Tasks->Export Data and this will invoke the export data wizard. The rest it pretty self-explanatory.
右键单击ssm对象资源管理器中的节点，选择Tasks->导出数据，这将调用导出数据向导。剩下的就不言自明了。
#2
2
Use right mouse click on your database >> tasks >> generate scripts
使用鼠标右键单击您的数据库>>任务>>生成脚本
After a few times 'next', you can select the tables from which you want to export the structure.
在“下一步”几次之后，您可以选择要导出结构的表。
To export the data, you can:
要导出数据，您可以:
- Right mouse click on your database >> tasks >> export data
- 鼠标右键点击你的数据库>>任务>>导出数据。
- or copy/paste from/to table data view
- 或从/到表数据视图复制/粘贴
#3
1
Yes, of course - the DTS-equivalent in SQL Server 2005 and up is SQL Server Integration Services (SSIS).
当然，SQL Server 2005和up中的dtd等效是SQL Server Integration Services (SSIS)。
You'll find that in your start menu under the SQL Server tab called Import and Export Data.
在开始菜单中，您将在SQL Server选项卡“导入和导出数据”下找到该选项。
If you need to do this operation often, you might also want to look at the bcp (bulk copy) command line tool for doing this kind of thing. This allows you to wrap the operation into a batch file and execute it regularly or on demand.
如果您需要经常执行此操作，您可能还需要查看bcp(批量复制)命令行工具来执行此类操作。这允许您将操作打包到一个批处理文件中，并定期或根据需要执行它。
#1
0
SSMS has a facility to do this available from the object explorer (somewhat counter-intuitively this is not available within BIDS). This invokes a wizard that generates an SSIS package that can export one or more tables to another database.
SSMS有一个工具可以从object explorer(有点反直觉的是，这在投标中是不可用的)实现这一点。这将调用一个向导，该向导生成一个SSIS包，该包可以将一个或多个表导出到另一个数据库。
Right click on the node in the SSMS object explorer, select Tasks->Export Data and this will invoke the export data wizard. The rest it pretty self-explanatory.
右键单击ssm对象资源管理器中的节点，选择Tasks->导出数据，这将调用导出数据向导。剩下的就不言自明了。
#2
2
Use right mouse click on your database >> tasks >> generate scripts
使用鼠标右键单击您的数据库>>任务>>生成脚本
After a few times 'next', you can select the tables from which you want to export the structure.
在“下一步”几次之后，您可以选择要导出结构的表。
To export the data, you can:
要导出数据，您可以:
- Right mouse click on your database >> tasks >> export data
- 鼠标右键点击你的数据库>>任务>>导出数据。
- or copy/paste from/to table data view
- 或从/到表数据视图复制/粘贴
#3
1
Yes, of course - the DTS-equivalent in SQL Server 2005 and up is SQL Server Integration Services (SSIS).
当然，SQL Server 2005和up中的dtd等效是SQL Server Integration Services (SSIS)。
You'll find that in your start menu under the SQL Server tab called Import and Export Data.
在开始菜单中，您将在SQL Server选项卡“导入和导出数据”下找到该选项。
If you need to do this operation often, you might also want to look at the bcp (bulk copy) command line tool for doing this kind of thing. This allows you to wrap the operation into a batch file and execute it regularly or on demand.
如果您需要经常执行此操作，您可能还需要查看bcp(批量复制)命令行工具来执行此类操作。这允许您将操作打包到一个批处理文件中，并定期或根据需要执行它。