sql 使用导入和导出向导

使用导入和导出向导

在 SQL Server 中的数据库之间复制表

原文:https://www . geesforgeks . org/copy-tables-in-SQL-server-使用导入和导出向导/

导入导出向导简介: 该向导允许简单地完成一个过程，并且只需编写很少或不编写代码就可以执行数据复制过程。但是，要将数据从一个源导入和导出到另一个源，可以遵循以下步骤–

Open the Object Explorer, select the database, right-click on the database name, and select Tasks and choose Export Data… option.
Now choose the data source, there are different sources that can be used. i.e., SQL Native Client 11.0, Select Server name and database name.
Now choose a destination Server name and Database and click Next.
Select the objects to copy data from table\view to the destination or write a query to data transfer and Click Next.
Choose Run immediately or Save SSIS Package and Click Next.
Summary of the actions that will be performed using the wizard will appear. Click Finish to execute the job steps.

向导成功完成后，表将在目的数据库中可见。