On Wed, Jul 15, 2015 at 3: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? > ----------------------- Must be ETL tools for Postgre. That might be the way to go for easier load of data in both directions. -- 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/CAJidMYJax=f1S_Ooh3qGh=xtvmnfywjcmygpc6rgcofzs+g...@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.
