[Greg Soulsby]

How do you run SQL script files from the MyEclispe SQL tool?

I have a number of SQL scripts in text files. I would like to mix and match native SQL in the SQL tool with my batch files.

But commands like “import” and “source”, which I found on the mySQL site, are failed by the SQL tool

Thanks

[support-swapna]

P0rridge ,

You can copy paste the contents of the script file into the MyEclipse MySQL Editor and run them. Alternatively you can copy the script files into the project , right click on the file > Open With > MySQL Editor and execute it.

If you are looking for something else, then please elaborate on what exactly you are looking for.

[Greg Soulsby]

I understand the copy and paste option.

I am generating SQL scripts from elsewhere, say to rebuild the database and to import fixed data from different sources.

I also want to write ad-hoc sql. So within MySql tool I would like to have the following lines

run script to re-build database;
run script to import data;
hand written sql statement/s here;
run script to export data;

Then I want to highlight the ones I want and ctrl F9 to run as usual.

[support-swapna]

P0rridge ,

1) Can you share your Build ID from Help > About MyEclipse Enterprise Edition > Build ID? Also share your Operating System and version details.

2) What are the errors you are seeing ? Clear the contents of the .log file which is located at <workspace dir>/.metadata/.log , replicate the issue and paste the errors logged here.

3) Also attach a screenshot of the SQL editor to help us get a visual.

[Author]

Posts