Written by

Senior Cloud Architect at InterSystems
MOD
Question Eduard Lebedyuk · Apr 4, 2023

DML export

Assuming I have an SQL table with data, is it possible to get DML export (INSERT statements for this data)?

Product version: IRIS 2022.3

Comments

Evgeny Shvarov · Apr 9, 2023

You need DML?

maybe csv export and import then could help?

0
Jeffrey Drumm · Apr 9, 2023

DBeaver offers this via Export Data, using the SQL option. Seems to work fine with IRIS. Doesn't seem to be an IRIS native feature, though.

0
Dmitry Maslennikov · Apr 9, 2023

I wanted to implement it as part of irissqlcli, but did not have time yet.

0