On 11/14/06, Gerd Wagner <bir...@t-...> wrote:
> You are absolutely right. I would even try to use the refactoring Plugin from
> within a Graph. Some time ago I introduced a mechanism that allows Plugins to
> communicate with each other. I did that to use the Scrips Plugin from within the
> Graph Plugin.
>
> One suggestion for the Refactoring Plugin: Could you allow to generate DDL
> Scripts in the SQL Editor?
Absolutely. I was thinking maybe a configuration (or button in
addition to the 'Show SQL') that would copy the refactoring SQL to the
editor and possibly execute it. At the moment, you can copy the SQL
from the dialog (ErrorDialog was probably a poor choice, I know) and
paste it into the SQL Edit tab. But I think it would be better to
give that option directly. It might have some overlap with the
SQLScripts plugin at some point. I was also thinking that the SQL
Scripts plugin can benefit from dialects for creating table scripts by
prompting the user to pick a target dialect to write the table script
in.
Once the refactoring plugin is reasonably complete (say in 20 years :)
and if no one else has implemented this in open source, the next
plugin that would be really nice to have is the database diff plugin.
For now you can simulate it by creating table scripts then diffing
them as regular files. It sure would be nice to combine the diff and
refactoring capabilities.
So many ideas, so little time...
Rob
|