How SQL server across server create a table and update the table structure information?

CodePudding user response:

Create a table, usually you can login to the remote server directly to create,
If it is according to the data of a server to update the data on the remote server, you can use to create good link server first, and then write the corresponding change the table structure of SQL statements,
Such as a simple example, actual situation, of course, you may need to completely different writing) :



Select *
Into [the target server's IP address]. [the database name]. [r]. Schema name, generally for the dbo newtable
The from [the IP address of the source server]. [the database name]. [r]. Schema name, generally for the dbo oldtable
Where 1=2

If the table has data, need to backup first done again fill rushed to the new data table,

CodePudding user response:

The first to create a link server:
https://blog.csdn.net/yenange/article/details/9456145