MS FoxPro to MS SQL Migration and Sync

Our software helps to migrate and synchronize MS Visual FoxPro databases .DBC or MS Visual FoxPro free tables .DBF to MS SQL Server. It combines an easy-to-use interface with bunch of customization options, so your migration and replication of data can be fulfilled smoothly and rapidly.

Approximately 1 Million of records from FoxPro to MSSQL Server with "Bulk" option activated can be converted in 8 minutes.

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 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 the conversion and synchronization processes by using built-in Scheduler. It allows users to execute tasks in a specified time interval.

Read here trial versions limitations

Product highlights

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

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)