Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to carry out data filtering and migration in DM7". In daily operation, I believe that many people have doubts about how to carry out data filtering and migration in DM7. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to carry out data filtering and migration in DM7". Next, please follow the editor to study!

How to filter and migrate data in DM7

When we encounter the need for data migration, often for the sake of efficiency and data security, we do not want to migrate the entire database or the whole table, but only want to export part of the data. DM7 provides a variety of graphical and command-line tools to meet the requirements of data filtering and migration. This article will show you how to use the tools included in the Dameng database to filter and migrate DM7- > DM7 data without installing additional software.

Solution

1. DTS tool

1.1.Using DTS tools to filter and export data

Using DTS tools, the data filtered from the source can be migrated to databases, SQL scripts, XML files, text files, etc., with a variety of migration modes to meet the needs of customers.

On the Windows platform, the DTS tool is located in the tool directory under the installation directory of Dameng database, as follows:

Take the DTS tool on the Windows platform as an example, and the export media is SQL script. The filtered data is exported as a SQL script, and when the data is stored, the SQL script is imported. When the network between the source database and the destination database is not connected, we can filter and migrate the data in this way:

First, select DM- > SQL for the migration method.

After entering the connection information on the source side, select the exported directory and character set

Choose to use query statements to filter data

Here we have the flexibility to use SQL statements to filter the data we need:

(it should be noted here that the destination mode is selected.)

Select the migration object and check the table to be migrated:

After the configuration is complete:

1.2. import with DTS tool

Select "SQL== > DM7" for migration method

Select the previously exported SQL script, enter the IP, port, user name and password of the destination database correctly, and click add File to add the exported SQL file, as follows:

1.3. Verify imported data

Source table data

Destination table data

At this point, the study on "how to carry out data filtering and migration in DM7" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.