While trying to import dbf tables to sql server using the Tasks > Import data > Microsoft OLE DB Provider for Visual FoxPro, and clicking Next I got this message:
TITLE: SQL Server Import and Export Wizard
The operation could not be completed.
Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
I'm using SQL Server 14.0.2027.2 and SQL Server Management Studio v17.9.1
I did install Microsoft OLE DB Provider, and in fact the Management Studio just presented it as an option. Others have asked the same question in internet but I haven't found an answer. Perhaps it requires a 32 bit version of SQL Server?
Thank you very much.
Alex
Right, your SQL is probably 64 bit and the VFP OLE DB is 32 bit. I would not recommend dropping your SQL down to 32 bit.
There are other tools that can move the data from FoxPro to SQL or other DBs.
I like https://www.easyfrom.net/ ESF Database Migration Toolkit. You can create and save migration jobs and do staging and testing before you send the final data to your Production database.
It's expensive at $322 USD.
There are other tools, too. And worse, you could write something yourself in VFP using a SQL ODBC driver. The question is which SQL ODBC driver. Some support newer data types like Date, like Varchar(MAX), SmallDate, DateTime2, etc. It's a bit of a mess to find and figure out which driver will work for your data.
Start this process with determining your SQL Datatypes and find the appropriate SQL ODBC driver. It's going to be a compromise choice. Or you can use Chen's magic VFP Advanced. I think he addresses/fixes some of the ODBC problems.
Good luck!
Thank you for the comments Jeff. Appreciate them.
Alex
You're welcome.
I'm just sorry that I don't have the full story on which SQL ODBC drivers support which SQL datatypes. I've researched it before and have written about it, too.
Maybe I'll give myself something to do and work something up.
If you do, a good place to put this is on the FoxPro Wiki - either directly or as a link to a white paper or blog post etc.
I've run into this many times myself and I also can't remember the details exactly as to what works and what doesn't with specific drivers.
+++ Rick ---