facebook

Running SQL txt files from SQL tool

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #321387 Reply

    Greg Soulsby
    Member

    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

    #321389 Reply

    support-swapna
    Moderator

    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.

    #321392 Reply

    Greg Soulsby
    Member

    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.

    #321421 Reply

    support-swapna
    Moderator

    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.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Running SQL txt files from SQL tool

You must be logged in to post in the forum log in