Toad World® Forums

Enhancements data export


#1

Hi,
I have an idea to add for data extract (that I usually need ),
that in data extract we can add a filter of the data if all tables chosen have the same common columns.

This feature already there in copy table to another schema; just to apply the same to data extract.

Thanks


#2

I'll consider the possibility,

but in the meantime, you could achieve this is in automation designer by making a series of exports, all writing to same file, and specifying same query but with different table for each one.


#3

Thanks for considering it,
but for the automation designer it always replace the file not appending,
how i can let it append to same file.

thanks


#4

There are options for that. Which Toad version are you on and which export format are you using (Excel, delimited, insert statements, etc)?


#5

i use generate merge statements


#6

oh, ok. Yeah there is no way to append files with that option.

You'd have to just export to separate files and then run each script separately.


#7

I'll look at adding where clause in there tomorrow. It should be an easy thing to add.


#8

Next beta:


#9

Thanks for update.
but actually i tried today with latest version, the where clause was with no effect, all data exported.
(I chose 2 tables with same where clause-applied together-with merge statement export )


#10

I just tested this in 13.2.0.112 and it worked as expected for me. The rows exported are limited by the "where" clause that I added.

On Monday I'll provide more details on how this should work.


#11

Here's a short video showing the effect of adding the "where" clause to the export. If multiple tables are involved and you want the where clause applied to all of them, you'll have to add it to each one. You can multiselect and right-click to do that. (I made a few minor GUI enhancements to this for next beta so it is easier to set up)

If you discovered some bug, please give me details so that I can reproduce it.


#12

I tried, it is working from automation designer, but not from schema browser.


#13

I see that, thank you. Fixed for next beta.