One of our clients has asked us to move an existing VFP app from DBF to SQLserver.
We plan to write a utility that will scan the whole project (programs + database), will create one cursor adapter class per SQL instruction met, and replace SQL instruction by cursorAdapter instantiation and/or call a method of an existing cursorAdapter. We’ll also write a complete upsize routine (that will probably enhance VFPx's upsizing wizard) so that we can migrate the data over and over until the whole data + code is OK in SQL. Of course we’ll have a test app running side by side with the production app. DBF to cursorAdapter will be a VFPx project. Thierry Nivelet FoxinCloud Give your VFP app a new life in the cloud http://foxincloud.com/ > Le 25 juil. 2016 à 16:13, Brant E. Layton <[email protected]> a écrit : > > Hi Tracy, > > Data stored in DBFs is most likely the limiting factor. Possible scenarios > are: > > 1. switch to SQL, then rewrite into a new environment later > > 2. rewrite into a new environment, bring the use of DBFs into the new > environment (perhaps not supported) > > 3. rewrite into new environment, converting data to SQL (or whatever) at > the same time as the new environment goes live > > It seems that #3 would be the best, but probably requires the most resource > and is the most risky. If #2 isn't possible, do #1. #2 seems like it would > be creating a new problem along the way. > > |Brant Layton| > |480.964.1316| > On 7/23/2016 6:58 PM, [email protected] wrote: >> Send ProfoxTech mailing list submissions to >> [email protected] >> >> To subscribe or unsubscribe via the World Wide Web, visit >> http://mail.leafe.com/mailman/listinfo/profoxtech >> or, via email, send a message with subject or body 'help' to >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of ProfoxTech digest..." >> >> >> This list is a distilled version of the main ProFox list. All messages with >> [OT] in the subject line have been distilled out, leaving just technical >> discussions. >> >> You cannot post directly to this list. Instead, please direct all replies to >> [email protected]. >> >> >> Today's Topics: >> >> 1. Re: [NF] Evernote vs OneNote (Man-wai Chang) >> 2. Re: [NF] Windows 10 upgrade out to lunch (Man-wai Chang) >> 3. Re: Going from DBF to SQL in frameworks (Man-wai Chang) >> 4. RE: [NF] Windows 10 upgrade out to lunch (Allen Pollard) >> 5. Re: [NF] Evernote vs OneNote (Charles Hart Enzer, M.D.) >> 6. Re: [NF] Evernote vs OneNote (Stephen Russell) >> 7. Re: [NF] Evernote vs OneNote (Charles Hart Enzer, M.D.) >> 8. Re: Going from DBF to SQL in frameworks (Tracy Pearson) >> 9. Re: [NF] Evernote vs OneNote (Malcolm Greene) >> 10. Re: [NF] Evernote vs OneNote (Charles Hart Enzer, M.D.) >> 11. Re: [NF] Evernote vs OneNote (Man-wai Chang) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Sat, 23 Jul 2016 17:16:34 +0800 >> From: Man-wai Chang <[email protected]> >> To: [email protected] >> Subject: Re: [NF] Evernote vs OneNote >> Message-ID: >> <CAGv=mjcv_p4hjfxn-taacs-hvsslzr5bywdxyfptgwqb9c9...@mail.gmail.com> >> Content-Type: text/plain; charset="us-ascii" >> >> I am using TreePad Lite as notes taking program. >> >> Never used EverNote! >> >> OneNote got OCR, if I remember correctly. And I have never attempted it. >> >> On Sat, Jul 23, 2016 at 5:21 AM, Charles Hart Enzer, M.D. >> <[email protected]> wrote: >>> What are the Advantages of Evernote? >>> What are the Advantages of OneNote? > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/[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.
