Would using SQL pass through be the best way to communicate with the SQL Server DB?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Monday, December 13, 2010 12:56 To: [email protected] Subject: Re: Migrating to SQL Server 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 [excessive quoting removed by server] _______________________________________________ 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.
