从一台服务器转移到另一台服务器然后你必须使用LinkedServer并传输数据。



使用此系统SP添加链接服务器：sp_addlinkedserver





如果您在数据库中进行传输，则使用带数据库名称的简单select into子句语句。

For transferring from one server to another server then you have to use LinkedServer and transfer the data.

use this System SP to add Linked server: sp_addlinkedserver


IF you are transferring within databse then use simple select into clause statement with database name.

您可以使用Sql Query

You can use Sql Query

Select * into destinationdb.dbo.tablename from sourcedbname.dbo.tablename

假设表格详细信息在databse1中，我们想将此表复制到database2然后

Suppose table "Details" is in databse1 and we want to copy this table to database2 then

Select * into databse2.dbo.Tablename from databse1.dbo.Details

这里db2.dbo.Tablename

表名你可以根据需要给出任何名字。

here db2.dbo.Tablename
Tablename u can give any name according to ur need.