Full SQL dump IBM DB2?

0 like 0 dislike
The work had to deal with the work of ibm, namely db2 9.7...

Question: how to make a full dump of the database in db2, including structure, data, procedures and other logic? like to dump it all to a file, similar in structure to dump the MySQL? db2look only saves the structure, as I understand it.

And maybe someone has had to convert databases between mysql and db2, which product is to use and how it is working?
by | 31 views

1 Answer

0 like 0 dislike
db2->mysql is a pain in the ass. and data better
I recreated the structure using sybase powerdesigner (there is a reverse enginering tools and RDMS convert from db2 to mysql).
If no db2 tables with blob/clob/text/xml, you can not sql-insert, and db2 export to "/path/to/file.txt" of del blablabla
a file with separator comma (and if there's a field with timestamp the export format dates need to ask)
in mysql it LOAD DATA
but it's a pain in the ass...

Related questions

0 like 0 dislike
3 answers
asked Jun 10, 2019 by Ellips
0 like 0 dislike
2 answers
0 like 0 dislike
7 answers
0 like 0 dislike
2 answers
asked Apr 11, 2019 by NikitaDanilov92
0 like 0 dislike
1 answer
110,608 questions
257,187 answers
40,796 users