Pervasive DataTools has the right tool for migrating data from Informix to almost any database without writing code.

The Data DownLoader from Informix connects to your source-side Informix database and to your target-side database via direct connection. Easily create each new table in your target database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data DownLoader from Informix that make migration from Informix a snap:

• Read Informix data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between Informix and your target database.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the Data DownLoader from Informix user interface, make needed changes, and get it right before writing any records to your target database.

The Data DownLoader from Informix is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data DownLoader from Informix and start migrating your data from Informix today!

- The Pervasive DataTools Team

Parse data from virtually any fixed-length Btrieve data file and convert the data to a CSV Text file with the Pervasive Data Parser for Btrieve.

The Data Parser for Btrieve supports dozens of Btrieve data types including 32-bit IEEE floating point, 64-bit IEEE floating point, Autoinc (2- & 4- byte), Bfloat (4- & 8-byte), Bfloat, Bit, Character, Comp, Comp-1, Comp-3, Comp-5, Comp-X, Date, Decimal, Float (4- & 8-byte), Integer (1-, 2-, 4-, & 8-byte), Logical, Logical (2 bytes), LString, LVar, Magic PC (Date, Extended, Number, Real, & Time), Microsoft BASIC Double, Microsoft BASIC Float, Money, Note, Numeric, NumericSA, NumericSTS, Packed Decimal, Sales Ally (Time-2, Date, Time-1, & Time), Unsigned (1-, 2-, 4-, & 8-byte), Zoned Decimal, and ZString. So whether you have a Btrieve DDF or you need to manually define the records and fields of virtually any Btrieve data file, the Pervasive Data Parser for Btrieve can handle the job. The Data Parser from Btrieve supports reading data from semi-structured Btrieve data files and provides a graphical interface in which you can manually define the data records and data fields or apply an external DDF dictionary file.

Export the unpacked data to a CSV Text file that can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Btrieve is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Btrieve and start converting your data today!

- The Pervasive DataTools Team

One of the most common issues encountered when performing data conversion is the problem of converting text to dates.

When dates are entered/stored as text strings, there are almost as many variations in the date formats as there are data entry users! Locale also plays a huge role in the wide variety of date formats. The task of converting text to a "true" date field in any application or database can be difficult and often requires "writing code" to translate the text strings to dates.

Pervasive DataTools Data UpLoaders are the solution for text to date conversion!

Each Data UpLoader includes two built-in features for handling text to date conversions, as follows:

• For text and spreadsheet data sources, each Data UpLoader can auto-detect data fields that contain consistently-formatted date strings. The transformation engine will auto-convert these date strings to the correct date format for your target application or database.
• In cases where the source date strings are not consistent, use the graphical expression builder that includes over 20 built-in date, time, and date/time functions to convert date strings to the correct date format for your target application or database.

The Data UpLoaders are available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader for your application or database and start converting your data today!

- The Pervasive DataTools Team

Convert data from virtually any fixed-length binary data file to any application, database, or other file format with the Pervasive Data Parser for Binary data.

The Data Parser for Binary supports dozens of data types including 16-bit binary, 24-bit binary, 32-bit binary, 64-bit binary, IEEE floating point, VAX floating point, Cray floating point, column binary, Comp, Comp-1, Comp-2, Comp-3, Comp-5, Comp-X, Display, Display Justified, Display Sign Leading, Display Sign Trailing, Packed Decimal, Pascal 48-bit real, Pascal string, Text, Zoned Decimal, Zoned-Leading Sign, and Zoned-Trailing Sign, and many others. So whether you have a COBOL copybook or you need to manually define the records and fields of virtually any binary data file, the Pervasive Data Parser for Binary can handle the job. The Data Parser from Binary supports reading data from un-structured binary data files and provides a graphical interface in which you can manually define the data records and data fields or apply an external dictionary file.

Export the unpacked data to a CSV Text file that can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Binary is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Binary and start converting your data today!

- The Pervasive DataTools Team

Pervasive DataTools has the right tool for migrating data from MySQL to PostgreSQL without writing code.

The Data DownLoader from MySQL connects to your source-side MySQL database via ODBC and to your target-side PostgreSQL database via direct connection. Easily create each new table in your PostgreSQL database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data DownLoader from MySQL that make migration from MySQL to PostgreSQL a snap:

• Read MySQL data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between MySQL and PostgreSQL.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the Data DownLoader from MySQL user interface, make needed changes, and get it right before writing any records to PostgreSQL.

The Data DownLoader from MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data DownLoader from MySQL and start migrating your data from MySQL to PostgreSQL today!

- The Pervasive DataTools Team

Pervasive DataTools has the right tool for migrating data from Microsoft Access to MySQL - without writing code.

The Data UpLoader to MySQL connects to your source-side MS Access database directly and to your target-side MySQL database via ODBC. Easily create each new table in your MySQL database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data UpLoader to MySQL that make migration from MS Access to MySQL a snap:

• Read MS Access data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between Access and MySQL.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the Data UpLoader to MySQL user interface, make needed changes, and get it right before writing any records to MySQL.

The Data UpLoader to MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader to MySQL and start migrating your data from MS Access to MySQL today!

- The Pervasive DataTools Team

Pervasive DataTools has the right tool for migrating data from SQL Server to MySQL - without writing code.

The Data UpLoader to MySQL connects to your source-side SQL Server database directly and to your target-side MySQL database via ODBC. Easily create each new table in your MySQL database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data UpLoader to MySQL that make migration from SQL Server to MySQL a snap:

• Read SQL Server data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between SQL Server and MySQL.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the user interface, make needed changes, and get it right before writing one record to MySQL.

The Data UpLoader to MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader to MySQL and start migrating your data to MySQL today!

- The Pervasive DataTools Team

Pervasive DataTools offers solutions for migrating data from ACT to SugarCRM.

ACT to SugarCRM data migrations can be problematic due to the necessity of linking child records to the parent records. The most common problem is retaining the relationship between the memo fields (child records that contain activities/events and history records) and Contact records.

The DataTools solution...

If you have the ACT application, you can create reports that contain both the parent (Contact) and child (Activities/Events/History) records. Then, print the report to a file on your workstation - rather than to a printer - and download the Data Extractor for Unstructured Text to extract the records, with relationships intact, as needed. Export the data records to a CSV file from the Data Extractor.

Then use the Data Builder for SugarCRM to map & transform the "raw" CSV data into the exact CSV structure that is ready to import into SugarCRM using the SugarCRM import utility.

- The Pervasive DataTools Team

Pervasive DataTools offers solutions for migrating data from Goldmine to SugarCRM.

Goldmine to SugarCRM data migrations can be problematic because Goldmine implemented a proprietary method of linking child records in the .DBT files to the parent records in the .DBF files in versions of Goldmine that used a dBASE format for record management. The most common problem is retaining the relationship between the memo fields (child records that contain activities/events and history records) stored in .DBT files and Contact records that are stored in .DBF files.

The DataTools solution...

If you have the Goldmine application, you can create reports that contain both the parent (Contact) and child (Activities/Events/History) records. Then, print the report to a file on your workstation - rather than to a printer - and download the Data Extractor for Unstructured Text to extract the records, with relationships intact, as needed. Export the data records to a CSV file from the Data Extractor.

Then use the Data Builder for SugarCRM to map & transform the "raw" CSV data into the exact CSV structure that is ready to import into SugarCRM using the SugarCRM import utility.

- The Pervasive DataTools Team

Pervasive DataTools provide solutions for your data conversion and data migration projects between virtually any application, database, file format, and/or web store.

Click on the links below to learn more about data solutions for your projects.

Application Solutions

Database Solutions

Data File Solutions

Web Store Solutions

Parse virtually any fixed text data file and export the parsed data to a CSV text file with the Data Parser for Fixed Text from Pervasive DataTools.

The Data Parser for Fixed Text supports reading data from fixed-length flat files and provides a graphical interface in which you can manually define the data records and data fields or apply an external dictionary file. COBOL copybooks, C structure, and other external dictionary files are supported.

The exported CSV Text file can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Fixed Text is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Fixed Text and start converting your fixed text data today!

- The Pervasive DataTools Team

The Pervasive Data UpLoader to IBM DB2 reads data from dozens of applications, databases, and file formats and writes the data to one or more tables in an IBM DB2 database.

Download a 90-day license for the Data UpLoader to IBM DB2 FREE for a limited time. Simply register on the Pervasive DataTools web site and start loading your IBM DB2 database today!

- The Pervasive DataTools Team

Convert data from virtually any fixed-length legacy COBOL data file to any application, database, or other file format with the Pervasive Data Parser for Binary data.

The Data Parser for Binary supports dozens of data types including 16-bit binary, 24-bit binary, 32-bit binary, 64-bit binary, IEEE floating point, VAX floating point, Cray floating point, column binary, Comp, Comp-1, Comp-2, Comp-3, Comp-5, Comp-X, Display, Display Justified, Display Sign Leading, Display Sign Trailing, Packed Decimal, Pascal 48-bit real, Pascal string, Text, Zoned Decimal, Zoned-Leading Sign, and Zoned-Trailing Sign, and many others. So whether you have a COBOL copybook or you need to manually define the records and fields of virtually any COBOL data file, the Pervasive Data Parser for Binary can handle the job. The Data Parser from Binary supports reading data from un-structured COBOL files and provides a graphical interface in which you can manually define the data records and data fields or apply an external dictionary file.

Export the unpacked data to a CSV Text file that can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Binary is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Binary and start converting your data today!

- The Pervasive DataTools Team

Do you need to import data into Amazon.com Store?

Pervasive DataTools offers a Data Builder that enables you to convert data from dozens of applications, databases, and file formats via native adapters using the Data Builder for Amazon Store. Map and transform virtually any source data into a CSV file with the exact structure required by the Amazon Store import utility. The resulting CSV file contains clean data records to import into Amazon Store.

The Data Builder for Amazon Store is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Builder for Amazon Store and start converting your data today!

- The Pervasive DataTools Team

Do you need to import data into eBay Store?

Pervasive DataTools offers a Data Builder that enables you to convert data from dozens of applications, databases, and file formats via native adapters using the Data Builder for eBay Store. Map and transform virtually any source data into a CSV file with the exact structure required by the eBay Store import utility. The resulting CSV file contains clean data records to import into eBay Store.

The Data Builder for eBay Store is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Builder for eBay Store and start converting your data today!

- The Pervasive DataTools Team