Wow. Tough question. But a good question. Appreciate a client who thinks about contingencies.
IIRC, FPD/FPW could only access SQL Server using a proprietary .PLB/.FLL client-server library. Is it possible to recompile the FPW app in VFP, just recompile, to gain all the benefits of working with VFP, including ODBC? PostgreSQL can be scripted to generate SQL files you could use to repopulate DBFs (I've done this), but if you're working with anything other than ints, floats, booleans, varchars and dates (NOT datetimes) you'll start hitting conversion issues. I'm sure you recognize that migration is another app you write in parallel with the new app you're developing. Two-way migration means two apps :) On Wed, Jul 15, 2015 at 4:47 PM, Kevin Cully <[email protected]> wrote: > Situation: I've created a proposal for a new client for upgrading an old > FPW2.6 application to a web based application using PostgreSQL as the DB. > The client likes my proposal but they're wondering that if they run out of > money during the project, could they create a way to pull the data down and > populate the portions of their FPW2.6 system that isn't converted yet. This > 'pull' would take place on a periodic basis. Every 30 minutes? > > I know that I can access PostgreSQL data via VFP, but I can't recall if > FPW2.6 can access PG data directly via ODBC. > > As a fall back, I could write a VFP application that could pull the data > down, and then kick off a process to populate the FP data tables. If I > remember correctly that if VFP accesses FP2.6 tables then VFP tries to > update the headers of the tables. > > This sounds like a major kludge. Best way to approach this backup plan? > > CULLY Technologies, LLC > http://cullytechnologies.com > http://cully.biz > > [excessive quoting removed by server] _______________________________________________ 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/cacw6n4vn81ke1kjomd1pd76ca8fflnwj2vydjpnfjoglt8f...@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.
