This isn't a really big deal, but I've noticed that if I copy a large file
(a database backup, for example) from a remote store to a local store
manually, I get a nice progress bar.  But doing the same thing through a
script, I don't.  Sure, I've set log statements just before and after the
copy and most of the time, the script would be running through a nightly
job, but I'm wondering how EDB Manager does it?

I looked through the code of EDB Mgr and found ExecuteSQL with a
DatabaseObject passed in which makes me think it's handled any other way
that long processes are handled. But there isn't a way to tap into an
OnProgress event from a script, I guess.

--
David Cornelius
Cornelius Concepts

David


The only way I can think of is to use the SET STATUS MESSAGE capability. However, once you hit something that is sort of atomic in nature (eg EXECUTE IMMEDIATE)  you've had it.


Roy Lambert