On Fri, Dec 27, 2013 at 8:51 AM, Rafael Copquin <[email protected]>wrote:
> I've had some experience with MS SQL Server Express as the data engine and > have a few applications running live, with VFP9 as the front end and MS SQL > as the back end. > > However, I want to experience how things would work with MySQL, especially > because I have a requirement to connect several stores of the same company > with a centralized server in the HQ. Due to the fact that there are > constant power failures in this country, especially in the summer (we are > now experiencing the most prolongued heat wave in 43 years, with power cuts > every single day, a real nightmare.We have been in weather red alert for > over two weeks now), I can't rely on a centralized server that would > service all the stores through the internet. > I am thinking of replication, installing a MySQL server in each store and > apply replication to update data on the head office and viceversa, update > the stores's servers with new products, prices, etc. This would help > tremendously when power goes off in the HQ. Once its up again, replication > would act to pull data from all the stores or send updates to their > databases. Conversely, the same thing would happen when power is cut at any > of the stores. > > MS SQL Server Express does not have replication (or rather, it is not a > full feature of it). My client is adamant that he does not want to pay for > a commercial version of SQL Server, as he is very happy with open source > software, especially because it is FREE. > ------------------- I do not think the DB is the critical choice here. The infrastructure is toast or so it seems. I would move to phone apps or Web apps and get away 100% from desktop environment. Is the internet stable from provider to HQ? If so does HQ have power backups to allow a graceful shutdown over 20+ min of dead time? Would HQ consider putting in a generator to feed the IT power as needed? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmylycakygcygkupopg8z1uklmggbxqd9aprrmaix1jj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
