When we do database programs, this often encounters this: you need to import data in a database server into the table of another database server. Usually we will use this method: first take out the data in a database to a certain out, then insert these data one strip into the destination database, this method is less efficient, and the program is also very cumbersome. easy to make mistake. Another method is to use the BCP or BULK INSERT statement to import data into a file, and then export to the destination database from this file. Although the efficiency is slightly higher, there is also a lot of unsatisfactory places, how is it in import? It is very troublesome to find another machine data import file. The most convenient way, I think it is the highest efficiency method, it should be like this: For example, there are two database servers: ZL and LJW, there is a database TAXITEMP (also different names), there is a table in the database, called User, we now want to import User data in ZL into the LJW, you can write SQL statements (assuming the ZL database now): Insert Into Ljw.TaxItemp.dbo.usersselect * from users, through a SQL statement Complete data replication between different database servers. Some people will say that this SQL statement will also write, I also thought, but there is no way to execute. Indeed, a simple such statement is not possible, because the database does not know what server is the server, nor does it know how to log in, of course, will report an error. We can solve the problem of registration of remote database servers and login: Register Remote Database Server: EXEC SP_ADDLINKEDSERVER 'LJW', N'SQL Server 'Registering the Login Method for Remote Database Server: EXEC SP_ADDLINKEDSRVLOGIN' LJW ',' FALSE ', NULL,' SA ',' ZZ 'is detailed for these two stored procedures, I don't talk about it, let's see help. As long as we first perform a remote database server registration and login method to register, then you can use the remote database as a local database.
