Converters for Microsoft SQL Converters for MySQL Converters for IBM DB2 Converters for MS Access Converters for Adobe PDF Converters for DBase/FoxPro Converters for Microsoft Excel Converters for Oracle Converters for Postgres MSSQL-to-Excel Converter MSSQL-to-MySQL Converter Intelligent Converters Software Access-to-MySQL Converter
incremental migration, select query, data filter, database, automate conversion, server, format, shareware
FAQ  |  Site map  |  Contact Us
About Us How to Buy All Products Discounts Migration Service Support Become a Partner Articles

Filtering data during the conversion process

It is very common situation when you do not need to migrate the entire table to another database format but just a part of it. Intelligent Converters offers smart and flexible solution for such situations. Now our products allow users to filter data via SQL SELECT-queries. With this feature, you can select particular columns or data subset or simply rename columns in the resulting table. Below there are some examples of using queries for different purposes. Assume that we have MySQL table "Table1" defined as below:

   Table1(
	ID INT NOT NULL AUTO_INCREMENT, 
	FName VARCHAR(50),
	LName VARCHAR(50), 
	Birthday DATE, 
	Notes TEXT
   );

Example 1. Convert certain records.

SELECT * FROM Table1 WHERE ID > 1000

Example 2. Select and rename certain columns.

SELECT FName as FirstName, LName as LastName FROM Table1

Example 3. Skip records containing NULL values.

SELECT * FROM Table1 WHERE Notes IS NOT NULL

As you can see, SELECT-query filter is a powerful feature that allows you to precisely control the data for converting. With this feature it is so easy to arrange incremental conversion and migrate exact data you wish. It would be definitely useful for daily backup tasks and similar procedures requiring partial data migration.