On 12/13/2010 12:01 PM, Stephen Russell wrote: > On Mon, Dec 13, 2010 at 8:57 AM, Anthony J. Gundrum > <[email protected]> wrote: >> What's the best way to migrate a FoxPro database and/or free tables to SQL >> Server and keep all the code written in VFP? > ----------------- > > Start with something TINY in your app today. Security tables and a > log in maybe? > > What version of SQL Server do you have?
Remote views. Do as little coding in xBase against tables as possible. Use an n-tier approach where the DataObj serves up VFP writable cursors and then you handle the saves (well, all the CRUD, really) in the DataObj. Paul McNett's Makeupdatable.prg is great for this. See the leafe.com/dls/vfp site for his code. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
