migrating foxpro to sql-server using c#

  • Thread starter Thread starter drgonzo120
  • Start date Start date
D

drgonzo120

hello,


i must convert a foxpro database tro a sql-server datase, and while
i'm thinking on it, are there any known programs??? maybe open source?
that do this job ??? because re-inventing the wheel is not that smart.
or if there isn't any, what driver should i use ???


thanks
 
hello, i asked what version it was, and it still was an MS-DOS version
of foxpro, with 15 years of data in it ...


so this shakes the cards whole differently ...

can you export to the database to a textfile ??? (and then import it
manually)


any suggestions ???
 
hello,


i must convert a foxpro database tro a sql-server datase, and while
i'm thinking on it, are there any known programs??? maybe open source?
that do this job ??? because re-inventing the wheel is not that smart.
or if there isn't any, what driver should i use ???
Click to expand...

About 4 years ago, I remember using SQL DTS to convert (or "import" I
should say) an Access database into SQL Server. The DTS wizard had all
sorts of connection options for the "source" database and I think Foxpro
was listed. Take a look at DTS (Data Transformation Services).
 
Hi,

| hello,
|
|
| i must convert a foxpro database tro a sql-server datase, and while
| i'm thinking on it, are there any known programs??? maybe open source?
| that do this job ??? because re-inventing the wheel is not that smart.
| or if there isn't any, what driver should i use ???

You can migrate the DB without problem, just use Import from the SQL
management console.

The code for using the DB is another matter, you would have to create the
front-end
 
Hi !

Others have suggested SQL Server DTS or the import wizard. To use it you'll
do best with the FoxPro and Visual FoxPro OLE DB data provider, downloadable
from the link below my signature. It works with all versions of Fox tables
including FoxPro for DOS.

As Ignacio said, you'll still need a front end for the data, which could be
written in MS Visual FoxPro, MS Access, MS VB.NET or C#.NET, or a web front
end.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
 
Back
Top