On Wed, Apr 29, 2009 at 3:20 PM, MB Software Solutions General Account > The VFP9-MySQL solutions I've got out there now working will not be > affected, imo, by the acquisition by Oracle. They cannot, imo, put > anything into place that would ill-affect my existing solutions. I may > not be able to upgrade for whatever personal/business reason moving > forward, but what works today should still work tomorrow and the day after > that, etc etc, imo. Right? > > Because I've designed with the n-tier approach, I'm going to take one of > my solutions and see if I can get the PostgreSQL backend solution as well. > The only place I'd need to change things would be where there's > MySQL-specific SQL that doesn't work the same in PostgreSQL. --------------------------
Are you currently using anything of MySQL outside of it as a storage container? Or have you put in logic that runs in the database that has nothing to do with VFP? These would be triggers, Stored Procedures, UDFs, customer data types. If the answer is no then you can switch to any one of free open source ones. Picking PostgreSQL for a reason is what you should be doing. Otherwise why switch, and go into all of that change process for your code base? Second part of the puzzle is where is this MySQL running? On your hardware where you have 100% control on version etc, or at a hosted site where they do it all for you, and you are at their whim in an upgrade? -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
