Export Query Result via SQL Inserts WITHOUT database prefix

Answered

Greetings,

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.

2 comments

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

0

@Nazar Aziz

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

or to use find & replace in your result file.

 

 

0

Please sign in to leave a comment.