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? >From VFP you can script out your current data via afields() right? >From that text file you could make Create table statements that would work in VFP. Put that output to a text file and then open it up as a script in your new DB that you just made. If you click on Parse it will help you identify what is NOT SQL Server compliant in your tables. After you tweak all the parse tries to a script that is acceptable just run it. Getting data to and from SQL Server from VFP may be your best bet because of your lack of knowledge with the SQL tool, SS Business Intelligence. From that you could suck in all the VFP data real fast to an existing table in SQL Server. Yoiu may have to make conversion in data from VFP to SQL Server. Memo fields, date fields come to mind. You have the ability to use varchar(50) instead of char(35) and that can save a lot of room depending on your actual data. At this point I would normalize the data to third normal. That will be your biggest pain because your data is probably second normal. All that VFP code would have to change :( -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
