Microsoft FoxPro to Microsoft SQL Server
Conversion & Sync.

 DBConvert for FoxPro & MSSQL

Version: 4.6.8

Release Date: April 25, 2019

Conversion directions:

  • MS Visual FoxPro → MS SQL Server, MS SQL Dump, MS Visual FoxPro Program
  • MS SQL Server → Visual FoxPro, FoxPro 2.6, MS Visual FoxPro Program, MS SQL Dump, *.DBF
  • FoxPro ↔ SQL Azure
  • MS Visual FoxPro, *.DBF ↔ Amazon RDS
 DBSync for FoxPro & MSSQL

Version: 4.6.4

Release Date: March 28, 2019

Synchronization directions:

  • FoxPro → MS SQL Server
  • MS SQL Server → MS Visual FoxPro, *.DBF
  • *.DBF → MS SQL Server
  • FoxPro ↔ SQL Azure
  • MS Visual FoxPro, *.DBF ↔ Amazon RDS

Our DBConvert/DBSync for FoxPro and MSSQL provides a powerful and comfortable way to convert and sync data from MS Visual FoxPro databases (.dbc) and MS Visual FoxPro free tables (.dbf) to Microsoft SQL Server, Windows Azure SQL databases.

All customizations for target databases are presented in a tree-like browser that greatly simplifies adjusting settings and handling your personal parameters.

1 million records from FoxPro to MSSQL Server with our Bulk option activated can be converted in only 8 minutes.

DBSync for FoxPro and MS SQL is the easiest solution for FoxPro and MSSQL/Windows Azure SQL databases synchronization. Intellectual synchronizer mechanism provides stable and accurate source data duplication to destination database on FoxPro and MSSQL platforms.

Three types of synchronization is a great guide to getting your databases updated.

FoxPro “End of life”, announced by Microsoft, forced companies that use Visual FoxPro for their mission critical programs to choose an alternative database platform for these systems. Even if FoxPro were still in support, FoxPro remains a file-server database, not suited for high-volume transactional applications. The most compelling reasons to move to SQL Server include the ability to handle big tables with a size greater than 2 GB and increased security options. We observe a trend to switch existing Visual FoxPro based applications to use SQL Server as the data storage engine. Both the free Express version and SQL Server Enterprise are great replacements for your retired FoxPro back-end data storage.

With proper data mapping between FoxPro source and MS SQL Server target database, specifying larger individual tables makes the whole conversion and data synchronization both flexible and easy.

Save your data to an SQL Dump file if you have limited access to the MS SQL server because of insufficient privileges. The destination file consists of MS SQL instructions to recreate all tables and load them with data.

Automate conversion and sync processes by using our built-in Scheduler. It allows users to execute tasks at a specified time.

NOTE: FoxPro General datatype is not supported.

Product Highlights

Product Requirements

  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)
  • MS Visual FoxPro version 9.0 and early, e.g. FoxPro 2.6

Latest News

  • Parameterized queries implemented. Conversion/synchronization speed increased approximately by 15%.
  • Conversion/Synchronization for SQL Azure added.
  • Speed enhancement for better conversion. About 1 million records in large databases can be transferred:
    - in 6 min. from MS SQL to MS FoxPro
    - in 8 min. from MS FoxPro to MS SQL (with "Bulk" option activated)
  • Customizable data filtering
  • Ability to choose DBF files for conversion/synchronization as a target
  • Variable quantization step added
  • Stable synchronization speed improvements. Now large databases are synchronized approximately in 100 times faster.