Filtering data during the conversion

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.