Microsoft FoxPro to Microsoft SQL Server Migration.

 DBConvert for FoxPro & MSSQL

Version: 4.6.6

Release Date: April 28, 2015

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

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa
 DBSync for FoxPro & MSSQL

Version: 4.5.9

Release Date: March 10, 2015

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

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

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

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

1 Million of records from FoxPro to MSSQL Server with "Bulk" option activated can be converted in 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 help to get your databases updated.

FoxPro “End of life”, announced by Microsoft, forces companies that use Visual FoxPro for their mission critical programs, considering alternative database platforms for these systems. Besides, FoxPro remains a file-server database, not suited for high-volume transactional applications. The most compelling reasons to move to SQL Server are ability to handle big tables with a size more than 2 GB and increased security options. The trend is switching existing Visual FoxPro based applications to use SQL Server as the data storage. Both free Express version and SQL Server Enterprise would be the perfect replacement of the retired FoxPro back-end data storage.

Proper data mapping between FoxPro source and MS SQL Server target database, specifying individual tables to upsize makes the whole conversion and data synchronization flexible and easy.

Save your data to 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 fill them with data.

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

Product Highlights

  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • Saving data into a MS Visual FoxPro Program file for export to MS Visual FoxPro database
  • Quantization feature
  • MS SQL schemes support
  • Speed conversion with Bulk and Quantization features
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • Amazon RDS SQL Server DB Instance support
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • MS Visual FoxPro free tables support
  • Saving data into a MS SQL Dump for export to MS SQL database

Product Requirements

  • MS Visual FoxPro version 9.0 and early, e.g. FoxPro 2.6
  • MDAC 2.8
  • 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)

Latest News

  • Stable synchronization speed improvements. Now large databases are synchronized approximately in 100 times faster.
  • 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