[Thomas Benz]

Can I address tables from two open connections and so copy data from one DB into the other.

For example something like that:

insert into db2:Table_2
select * from
db1:Table_1

Thanks
Thomas

[Riyad Kalla]

I am researching this.

[support-jeff]

Not at this time, but it is an intriguing idea, Thomas. I will enter an feature enhancement request on this.

NOTE: if you are dealing with tables in different *schema*, then yes you can do as you suggest.

[yfowler]

Hi Jeff,

Has this functionality been added since this post? I’m currently using MyEclipse Database Explorer version 6.0.0 GA.

Thanks for all the work,
–Y

[Riyad Kalla]

yfowler,
The SQL editor is still executed against a single connection, that you can choose from the dropdown at the top of the SQL Editor.

[Author]

Posts