August 14, 2004 at 5:00 am
Dear Experts
Can any one please help me in MIGRATION of table from Foxpro 2.5 and MSVisualFoxpro 6 to
MSSqlServer 2000
I had a large no of table in foxpro now i want all of them in SQL SERVER 2000
- Manish
August 16, 2004 at 6:18 pm
DTS should do everything you need.
August 26, 2004 at 7:28 am
Hi Manish
First of all, try to always be specific in your title:
eg: Migration from VFP and Foxpro to SQL Server
Secondly try and search for the same subject in this forum or others:
eg: http://www.google.com : Foxpro VFP DTS SQL 2000 migrate
FoxPro to Sql 2000 Migration Posted 11/10/2003
http://www.sqlservercentral.com/forums/ shwmessage.aspx?forumid=54&messageid=18009
How to: Data Migration Posted 7/12/2004 1:13:00 PM
http://www.sqlservercentral.com/ forums/shwmessage.aspx?messageid=125940
Thirdly, as I can see you from your posting that you are familiar with SQL, go to the SQL Entreprise Manager, right-click virtually anywhere and choose "all tasks" "Import data" and the Data Transformation (DTS) Wizard will start.
Basically if you don't use the upsizing wizard for VFP, then you can (download from Microsoft MSDN and) use the VFP OLE DB driver from SQL via DTS and save the whole conversion into a DTS package which you can tweak and re-use many times (until you go live with SQL)
Many problem such as VFP/Foxpro memo becomes SQL text by default, change it to SQL varchar(8000) or nvarchar(4000) ... most columns in SQL tables should be made NON-NULL except optional VFP dates which are best left as NULL columns in SQL Server...
Your saved DTS package can contain the deletion + creation of each SQL table as well as a SQL string to transform your data:
eg: DMY(`MyDate`) +SPACE(1)+ IIF(VAL(LEFT(`MyTime`,2)>0,`MyTime`,"00:00:00") as `MyNewSQLDateTime`
Add a error log/text file to see the error messages and the failed row
Put an ORDER BY in your SQL string to replicate the way you look/check/correct the VFP data
I could go on longer and sorry if I sound a bit abrupt but I've wasted lots of time as this stupid system timed out/lost my previous longer reply (twice during preview) and that really p..sed me off.
Alain
August 26, 2004 at 9:53 am
Hi again Manish
I'd just like to add this link to a good (if rather old) white paper:
---------------------------------------
http://www.eps-cs.com/pdf/whitepaper_migrating.pdf
Migrating Your Visual FoxPro Application to a Client/Server Platform
by Dan LeClair
This article details issues you may encounter in migrating your monolithic Visual FoxPro (VFP) application to a client/server platform, specifically with SQL as the database. In addition, this white paper offers many tips for ensuring a successful migration.
---------------------------------------
There are more at http://www.eps-cs.com/white_papers.aspx
such as:
http://www.eps-cs.com/pdf/whitepaper_tsql.pdf
Introduction to T-SQL
by Eric Huckabay
This white paper introduces general concepts of Transact-SQL (T-SQL), including querying and data modification commands. Written for novices to T-SQL, this white paper seeks to provide a common foundation of knowledge from which to build.
---------------------------------------
Alain
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply