upsizing to SQL

Article View: bit.databases.mssql-l

Article #230

Back to bit.databases.mssql-l Previous Next

#230

From: Bobby
Date: Thu, 02 Sep 1999 00:00

26 lines
2644 bytes

i know i'm probably putting this in the wrong place ....

if anyone out there has successfully migrating a 'foxpro 2.5b for windows"
d/base to SQL server (6-7) i'd be interested to hear how you approached it.

I'm looking for a simple overview as to the best way of accomplishing this
(the technical details such as mapping of different data-types between SQL
and FoxPro are no doubt well documented).

getting a useful front end for my client/server solution is not an issue
because i'll be using Access to develop a new one ... just need to get from
the current file/server foxpro solution to an SQL Server back end.

my plan at the moment is to upgrade to Visual FoxPro (whatever the latest
ver is) and then use the upsizing wizard to take it to SQL and then , fix
anything that gets lots or damaged in the process. from what i can gather
the upsizing wizard is less than perfect so i may have my work cut out from
me. Part of the problem as well is that I have very little foxpro
background.

if there is a better way , or you have some experiences to relate that i
might useful ,, please let me know!!

rob

robert.ellis3@virgin.net

Technical Details

Message-ID: <7qmoh2$ag8$2@nclient11-gui.server.virgin.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff490,d85752fc178dc426,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 10496a,d85752fc178dc426,start
X-Google-Attributes: gid10496a,public
X-Google-Thread: f45ea,d85752fc178dc426,start
X-Google-Attributes: gidf45ea,public
X-Google-Thread: f6611,d85752fc178dc426,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 11355a,d85752fc178dc426,start
X-Google-Attributes: gid11355a,public
X-Google-Thread: 10de66,d85752fc178dc426,start
X-Google-Attributes: gid10de66,public
X-Google-Thread: 106afd,d85752fc178dc426,start
X-Google-Attributes: gid106afd,public
X-Google-Thread: 104de1,d85752fc178dc426,start
X-Google-Attributes: gid104de1,public
From: "Bobby" <robert.ellis3@virgin.net>
Subject: upsizing to SQL
Date: 1999/09/02
Message-ID: <7qmoh2$ag8$2@nclient11-gui.server.virgin.net>
X-Deja-AN: 520343309
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Complaints-To: abuse@virgin.net
X-Trace: nclient11-gui.server.virgin.net 936306018 10760 212.250.194.124 (2 Sep 1999 21:00:18 GMT)
Organization: Virgin Net Usenet Service
X-MSMail-Priority: Normal
NNTP-Posting-Date: 2 Sep 1999 21:00:18 GMT
Newsgroups: bit.databases.mssql-l,bit.listserv.sqlinfo,borland.public.delphi.database.sqlservers,comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.de.sqlserver,microsoft.public.es.vfoxpro,microsoft.public.fox.vfp.queries-sql,microsoft.public.