I nearly wiped out a critical configuration file in my database today when I
scripted the “correct” version of a number of rows to a SQL Script to be deleted
and then re-created in a production database.
The problem was that by default Toad seems to be “not” retrieving ntext fields.
I didn’t notice that until after I generated an export SQL Script and just
happened to notice the fields were missing.
It would be most appreciated if a warning could be added when you select data
and choose export that there are fields that have not been retrieved, and
perhaps a prompt to retrieve them prior to performing the export.