SQL Server Performance Forum – Threads Archive
How to convert Xbase to SQL Server
The app backend is on Xbase dbI need to change it to run on SQL Server
Is that possible to do by import utility:I don’t see Xbase in data sourse list
Or i have to designg new db in SQL similar as in Xbase?
As far I know, you must to design new SQL database.
I suppose you can fine a method to migrate data, may be via Excel 1rst. Luis Martin
If there is a OLE DB Driver available of XBase DB, install the same on SQL Server box and you’ll see XBase option in the data source list. HTH. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Every day I learn something new ….
Luis Martin
Actully to be more precise – Any data source which has an OLE DB provider can be used to connect to SQL Server. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Thank you very much .
But where do i look for OLE db driver for Xbase?
How to install in in SQL if i find one?
I found Apollo ole db provider which according to them is ole db provider for xBase.
It’s not working though
xbase is the same as .DBF files. Microsoft has drivers for that, you can try to download an odbc entry for Microsoft Visual Foxpro and that should work fine. I have done that many times.
-David
-David Roesch
San Diego, Ca
]]>