Company two LAN 2 system database are exactly the same set of table structure, now need often from several tables in a database, export data to update the replace another LAN with watches in the database, data about 200000 or so, the update frequency of once a week, do you have any good idea, try not by technical personnel, not through DTS, I think you can make a small program, the export and import process, let non-technical people also can be manipulated, but the train of thought, a great god taught in qing dynasty,
Add, two local area network (LAN) cannot be connected to each other, through the way of U disk exchange data on a regular basis

CodePudding user response:

Can use the SQL Server's own Replication tool (Replication),
Every time synchronous data:
1. The first set of 2 LAN network.
2. The synchronization process.
3. The synchronization is complete, disconnect the two LAN.
Achieved through the method of the script.

CodePudding user response:

reference 1/f, started the first response:

can use the SQL Server's own Replication tool (Replication),
Every time synchronous data:
1. The first set of 2 LAN network.
2. The synchronization process.
3. The synchronization is complete, disconnect the two LAN.
The entire script way.

All have already said that cannot be connected to the Internet,

CodePudding user response:

If temporarily connected to the Internet is not workable, you can at the source end BCP is used to derive the table data to a file, and then in the destination end with BCP import.

CodePudding user response:

reference 3 floor started the first response:

if temporarily connected to the Internet is not workable, can at the source end BCP is used to derive the table data to a file, and then in the destination end with BCP import.

Hello do you have any visible operation BCP similar tools, because there's no professional operation in another local area network (LAN),

CodePudding user response:

Fixed several tables of data, oneself write a simple program can,
Or generation of a simple import and export tools, teach your colleagues use method also line
Reference: https://www.cnblogs.com/Leo_wl/p/3815722.html

CodePudding user response:

reference 4 floor qq511388601 response:

hello any visible operation BCP similar tools, because there's no professional operation in another local area network (LAN),

BCP is an executable under DOS command, can be encapsulated as desktop application (such as winform) to users.

CodePudding user response:

Thank you very much for the above several great god's instruction, I study well, thank you!