Now the company to do chain, headquarters in a SQL database, each branch of a SQL database, the use of the exchange of data pipeline found quite slow, and often a deadlock, I want to ask is there any other way you can refer to, for example to generate an XML file to the headquarters, but go up how to keep his trigger to perform, and how to deal with duplicate data, is there any successful chain, consult

CodePudding user response:

So you are doing well, ah, my company is doing research and development, are free to communicate communication,

CodePudding user response:

I know the branch of management to is this:
File management module by all information, and then manually regularly or irregularly distributed the information file out,
In a division is the file management module, not only the business processing module, and regularly or irregularly to business data back to headquarters,

Sending packets to plan a lot, simple is exported as TXT, always, in the division of export import interface makes all, is not difficult,

CodePudding user response:

I had contact is via FTP upload TXT guide entered again on to the server,
Download what is TXT, FTP download to the client,
Or can be,
Some of the new technology does not necessarily fit,

CodePudding user response:

About the head office and branch chain data exchange problem: http://blog.csdn.net/fstao/archive/2011/03/27/6281159.aspx

CodePudding user response:

Thanks for sharing!!!!!!!!!!

CodePudding user response:

Sybase ASE, ASA a remote SQL database and mobilink data replication synchronization technology, automatic synchronization between headquarters and stores database, very good,

CodePudding user response:

The best solution, I think, or use a database, the headquarters of the database, all the client access to the database, data changes won't delay, consistency and real time can be guaranteed, less maintenance workload,
How can to headquarters database can be on the Internet, a, can rent a fixed IP, second, if you don't want to rent, the high cost of suspicion, renting the broadband, and then use the peanut shells, it can be dynamic IP resolves to a fixed site, http://www.oray.com/online to see you will understand,

CodePudding user response:

Network development has entered the 3 g era, how to also adopt 03, 04 s solution

CodePudding user response:

Can cooperate database synchronization software, automatic synchronization database data regularly,
If each function should write their own code derived data, maintain and update the cost is too big,

CodePudding user response:

I also involves the problem next, want to automatically, don't manual solution, we talk,

CodePudding user response:

Using HTTP is to transmit the most convenient, pb also support, inet. Post, using asp. Net PHP JSP and so on have a server with respect to ok, webservice, too

CodePudding user response:

Chain business is divided into business and front sales, business systems are generally and headquarters to connect directly, while sales side in the local database, update the local data when each time a user login,

CodePudding user response: