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.

4 comments
Comment actions Permalink

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

0
Comment actions Permalink

@Nazar Aziz

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

or to use find & replace in your result file.

 

 

0
Comment actions Permalink

I have the same problem. Was doing a migration and realise I couldn't omit the DB name, had to use `sed` to search and replace in the end. 

Would be good to make it an option to omit or include the prefix as I believe not everyone names the db locally and remote the same.

0
Comment actions Permalink

@resting,

Feel free to change groovy script for your needs.

0

Please sign in to leave a comment.