Export Query Result via SQL Inserts WITHOUT database prefix



I am attempting to export the results from an SQL from one database into another. The export is generated by all the insert statements have a database prefixed table names, which makes the export useless for me as I want to load the inserts into a different database.

Is there a setting I can disable this behaviour - i.e. do not prefix the table name with a database name?

Thank you for any help.


Hello? Is this possible? The current export is useless for me.


@Nazar Aziz

To change default behavior for export  you need to modify groovy script:

or to use find & replace in your result file.




Please sign in to leave a comment.