[coemergence]

Hi All,

I am looking to use the MyEclipse DB Explorer as a replacement for MS Query Analyzer. For me to do so, I need the DB Explorer to be able to accept batches. I have alot of already existing *.sql files contained within our Eclipse project, and they have all been written such that they contain the Query Analyzer keyword of “GO” as a seperator for the different batches. Any idea when such functionality/ability will be available in MyEclipse DB Explorer? Its the one ability that is preventing me from fully adopting MyEclipse for everything I do. At least please consider it for a future version.

John A. Bowman

[Riyad Kalla]

Moving to enhancement requests and firing this off to our DB dev to have him evaluate its potential.

[mike_miller]

No offense to the MyEclipse Team meant here… but I think (my opinion) you’re mad to replace Query Analyzer with the MyEclipse plugin. Fair enough you might want a fully integrated enviroment but you’ll lose so much by doing this. Execution plan support within Query Analyzer is by far the best I have used. The Query Analyzer context help is another good reason not too… Doesn’t script existence checks, views…. the list continues….

Like the feature request though… Sorry for the rant : Frustrated Oracle 9 user sits here, and i would love batch support (if i still used MSSQL <sulk>) …. I’ve found that using ; as a statement separator can work in the same way (only tested with Oracle queries) …

🙂

[coemergence]

You are correct. You cannot replace Query Analyzer for its abilities for checking the code, and execution plans, etc.

What I want to do is to be able to open up an already existing peice of .sql code and simply execute it within the MyEclipse DB Explorer. For the other non-DB developers here, it would save an enormous amount of time and headache. They would just need to connect to a server, select the database they want, then execute.

For me to be able to do that, I need it to accept and be able to run batches. That being said it not only will need to be able to configure the batch seperator (“GO”), but also stream the results to a common dialog (a message tab perhaps) in a similar manner that Query Analyzer does it. It would be seperate from any actual “query results”. I output alot of statistics so I can monitor what my code is doing and how its behaving (usually via PRINT statements, crude logging yes I know).

[Dennis]

What is the status of this enhancement? The ability to have batches (with “go” or “;”, or whatever as a terminator) is a must for me to switch to DB Explorer.

[Author]

Posts