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

This article will explain in detail how to realize the migration of oracle data to db2 database. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1. Table structure migration

Select the table in plsql-> dbmsMetadata- > ddl

Note: at this point, the creation of the table, constraints and other information will be displayed in the window. You can directly copy the value sqldbx (the tool for connecting to the db2 database) to modify the type of the field in the statement that creates the table, such as converting varchar2 to varchar,number to integer. There are also changes in primary key and unique.

2. Table data migration

In Plsql, select Table-> right-click-> qurey data (shows all data)-> Select the data to be migrated-- > right-> export results---- > sql file

After obtaining the sql file, you can open it directly in the sqldbx. Modify the relevant parameters can be run directly. These sql files correspond to the insert statements in oracle, and the data can be imported into the db2 database as long as the insertion format of the relevant fields is modified.

Postscript: when moving database data, I found that I don't know a lot of knowledge about the database. For example, ddl gets a lot of statements, followed by index, sequence, unique, view and so on. We usually have to sum up more.

This is the end of the article on "how to migrate oracle data to db2 database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.