Trying to import a set of VFP free tables to Sql Server Express 2019 I did the following:
- Created a database in Sql Server Management Console8
- Opened the Sql Server Import Export Wizard
- Chose Microsoft OLE DB Provider for Visual FoxPro
- Upon clicking Properties or Next got this message:
The operation could not be completed. ADDITIONAL INFORMATION: Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
Can someone offer some suggestions please?
TIA,
Alex
This is a really good upsizer, but they've doubled the price to $322.
You can first use it to create the table structure in SQL Server. You can edit the job down to each column. You can save jobs and re-run them. You can edit the jobs and point them to use a different server which would allow you to upsize to test, dev, and production.
I've used it a lot. It works with MySQL and MSSQL and a lot of others. It's fast.
It's got a strong wizard type interface to create the upsizer that you can immediately run or, again, save as a job.
ESF Database Migration Toolkit
https://www.dbsofts.com
Free tables, you say?
Not sure if ESF Database Migration handles those. And that's might be why the OLEDB doesn't work.
You might have to manually create the structures in SQL Server and then write your own FoxPro upsizer using a SQL Server ODBC driver to the SQL Server database.
I use the upsize wizard in fox pro (the updated vfpx version) and it works well. It doesn’t work on free tables but you can dump tables into a DBC and then run it. It works well for straight updates but you won’t get any hard relations (which you didn’t have before either I guess).