Want to get a table in the database on a server to import the database to another server, how to operate, strives for the great god give advice or comments

CodePudding user response:

My is SQL Server2008 database

CodePudding user response:

Fastest link server

 EXEC master. The dbo. Sp_addlinkedserver @=N 'link server name server, @ srvproduct=N' @ the provider=N 'SQLNCLI' @ datasrc=https://bbs.csdn.net/topics/N 'XXX. XXX. XXX. XXX' 
The EXEC master. The dbo. Sp_addlinkedsrvlogin @ rmtsrvname=N 'link server name, @ useself=N' True ', @ locallogin=NULL, @ rmtuser=NULL, @ rmtpassword=NULL 
EXEC master. The dbo. Sp_addlinkedsrvlogin @ rmtsrvname=N 'link server name, @ locallogin=N' local login user '@ useself=N' False '@ rmtuser=N' remote login users' @ rmtpassword=N 'remote login password' 

- existing table 
Insert into existedTable (fieldsList) 
The select fieldsList link from the server name. The name of the database. Dbo. Table name 

- there is no table 
The select fieldsList 
Into the new table name 
The from link server name. The name of the database. Dbo. Table name 

CodePudding user response:

All can be done with the import and export wizard, a graphical, more convenient,

CodePudding user response:

Thank you very much!!!!!!!!!!!!!!!!!!!

CodePudding user response:

Thank you very much!!!!!!!!!!!!!!

CodePudding user response:

reference gypsy song reply: 3/f

can be done with the import and export wizard, complete graphical, more convenient,

When the change of the original data is no longer the import is more convenient, if the original database is still in use, the data also in changes, more convenient link server