MSSQL TO FOXPRO CONVERTER
MSSQL to FoxPro Converter is a tool to Convert, Export data from FoxPro DBF file to MS SQL Server Database or from MS SQL Server to FoxPro DBF files or Visual Foxpro DBC. You can convert multiple tables in one go. While converting you can map source table columns to matching destination table columns and. filter rows by specifying WHERE conditions.
It comes with a built in scheduler to enable you to schedule transfer jobs at specified intervals. No need to run jobs repeatedly, just create a session define the schedule date and time and FoxPro to MSSQL Converter will automatically executes your session in the background and records the actions in a specified log file. .
You can also run migration job manually through command line interface
Using MSSQL to FoxPro Converter you can perform the following conversion
- FoxPro to MSSQL Database
- FoxPro to MS SQL Server SQL Dump file
- MSSQL to FoxPro Database / DBF files
- FoxPro to FoxPro Database/ DBF Files
- MSSQL to MSSQL Database
- MSSQL to MS SQL Server SQL Dump file
UPSERT and INSERT
UPSERT
This feature will update the row in the MSSQL table if a matching row exist otherwise if the matching row does not exist it will insert a new row.
INSERT
This feature will insert a row in the MSSQL table only if the matching row does not exist
Other Features
- Supports UPSERT and INSERT loading options.
- Imports Constraints and Indexes
- Wizard based
- Map Source Columns to Target Table columns
- Specify WHERE conditions to filter data
- Save and Schedule of Sessions for recurring data transfers.
- Fast Speed
- Completely user friendly
- No need to write any code
- Repository Database is introduced.
- Select single or multiple tables to transfer
- Select or Deselect Columns while transferring
- Change Destination Datatypes and widths
- Automatic Checking of Datatype mismatch
- Rated Best in the category by many websites
- Most Popular product in Database App. section in download.com
- Economical costs just $99 For Standard Version
- Fully functional Trial version with just 50 rows limit is available
- Transfer Millions of rows easily and fast. That’s what our existing Customers are doing
- Supports Long , Picture Data types. In a jiffy you can copy data without any coding
- Supported O/s: Win 2003,Win 2000, XP, Win ME,Win98 & Win95
Supported Databases
- MySQL
- MySQL Dump
- Oracle
- Oracle SQL Dump
- MS Access
- PostgreSQL
- Foxpro/DBF Files
- CSV/Text or Fixed width
- MS SQL Server
- MS SQL Server Dump
- Maria DB
- Amazon RDS
- Amazon Aurora
- Google Cloud
- Azure Database for MySQL
Top Features
Constraints and Indexes
Imports all Constraints and Indexes and Auto Increment attributes.
In Built Scheduler
Automatically transfer data without any interaction.
Bulk Loading
Bulk Loading feature for Oracle, MySQL and MS SQL Server databases to load millions of rows at blazing speed.
Column Mapping
Load into new or existing tables with full Column Mapping.
SQL DUMP FILES
Generate SQL dump files from any database source
Synchronize
UPSERT and INSERT loading options to Synchronize Source and Target databases.