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 regular data backup and
similar procedures requiring partial data migration.
