With 7, 8 years system (c/s), using delphi7 + sql2005, now the customer request several subsidiaries are used at the same time, consult everybody, have what good plan?

CodePudding user response:

If the unit can be directly connected to the head office, they don't need to do to change, if you are concerned about the data security issues, then changed to three layer structure (such as datasnap)

CodePudding user response:

With a fixed IP SERVER room, also can use with the function of VPN firewall or router, make network management to SQL SERVER mapping to the VPN LAN, client connected via VPN dialing into the VPN LAN

If there is no fixed IP, personal feel rent cloud server, is better than renting fixed IP

CodePudding user response:

So your SQL SeRVER can avoid exposing the net, in the company information confidential terms is very safe, but the premise is that your VPN network equipment

CodePudding user response:

SQL SERVER can only use subscription/copy remote synchronization data, in a way that could be deployed in the subsidiaries of the local database, and then a master database in head office or room, use VPN to establish a secure connection

CodePudding user response:

"Now the customer request all at the same time with several subsidiary" : 1, each unit using a separate database or 2, all units share the same database?

1, is easy, find out the ADOConnection (assuming the ADO SQL operation), change the database name inside to read from the registries, then each unit a registry,

2, also is not difficult, this depends on the software on data have given more warehouse operating point of the problem, if you have, a direct use; If not, don't effort to change, change is not as good as reference 1 processing, and then do another front desk query, cross database statistics, financial room to headquarters, boss look at the overall situation,

CodePudding user response:

The previous directly to the database in the cloud server, IP or head office have the network, can direct access to the original program,
Generally exists but the network is slow, and easy to drop, the risk of exposure and database,
The simplest solution, can modify the connection string into three layers,
https://blog.csdn.net/pcwe2002/article/details/52527782

CodePudding user response:

Recently wrote a small program, to do the company's customer service knowledge base, LAN will do the trick, but some customer service to work from home, still have to make the network; Now are also trying to change 3 layers

CodePudding user response:

There are two kinds of schemes available, buy a VPN network, two webserive software on the server is a development program, each division with, both I used, (there is a kind of optical fiber line)

CodePudding user response:

VPN + remote desktop, converted into multi-layer, don't use the Delphi development

CodePudding user response:

Ali cloud can also