How to insert data across databases ???????

dawei9527

I want to copy the data from another database table
Because the table in the other database is the same as my current table, I want to copy it over
Don't know how to get it
How to batch insert across databases ??????????

lj0917

This can be done with SQL Server's import and export tools.

lj0917

If two databases are on the same server, you can directly

insert into tablename (column name 1, column name 2 ...)
select (corresponding to column name 1, corresponding to column name 2 ...) from [DataBaseName] .dbo.tablename




If there are two databases on two servers, you need to establish a connection server.
--Create a linked server
exec sp_addlinkedserver 'srv_lnk', '', 'SQLOLEDB', 'Remote server name or IP address'
exec sp_addlinkedsrvlogin 'srv_lnk', 'false', null, 'user name', 'password'
go
 
-


insert into tablename (column name 1, column name 2 ...)
select (corresponding to column name 1, corresponding to column name 2 ...) from srv_lnk. [DataBaseName] .dbo.tablename

恶魔右指

If two databases are on the same machine,
insert B library.dbo.table A
select * from A library.dbo.table A

prajna

The stars upstairs are all right