FoxPro Programming
Upsizing VFP tables to Sql Server
Gravatar is a globally recognized avatar based on your email address. Upsizing VFP tables to Sql Server
  Alejandro A Sosa
  All
  Dec 22, 2020 @ 08:28pm

Trying to import a set of VFP free tables to Sql Server Express 2019 I did the following:

  1. Created a database in Sql Server Management Console8
  2. Opened the Sql Server Import Export Wizard
  3. Chose Microsoft OLE DB Provider for Visual FoxPro
  4. 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

Gravatar is a globally recognized avatar based on your email address. re: Upsizing VFP tables to Sql Server
  Jeff L
  Alejandro A Sosa
  Dec 23, 2020 @ 04:24pm

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

Gravatar is a globally recognized avatar based on your email address. re: Upsizing VFP tables to Sql Server
  Jeff L
  Jeff L
  Dec 23, 2020 @ 05:43pm

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.

Gravatar is a globally recognized avatar based on your email address. re: Upsizing VFP tables to Sql Server
  Rick Strahl
  Alejandro A Sosa
  Dec 25, 2020 @ 10:35am

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).

© 1996-2021