Any alternative to Sybase Sql Advantage?

Question

Sybase Sql Advantage is the default editor for the Sybase database. But this has many disadvantages, because basically it is Notepad for Windows users:

• Unable to perform multiple undo
• Monochrome, the text is black, and the background is white.
• It is impossible to see which character you are pasting from the clipboard, and sometimes this leads to behavior in weirdness.
• You do not see which row or column is currently located.
• Lack of functionality, such as export to various formats, integration with a control source, plugins, etc.

I have to deal with this editor in my daily work, so I was wondering if there is another tool. Do you know any replacement?

Answer 1

There is TOAD and AQUA but none of them are free, although the demos let you try before buying. I use ASEISQL , which is free and does a lot of what you are after very well. I can not imagine how to return to the benefits of sql.

Answer 2

I like Aqua Data Studio - and they are not expensive for personal use. In addition to Sybase, a number of other database servers are supported in one interface. Written in Java, the application really works anywhere - for example, I use it on FreeBSD. In fact, FreeBSD already has a databases / adstudio port.

Answer 3

Notepad ++ SQL . Notepad ++ IDE SQL.

: http://notepad-plus-plus.org/

, , Sybase SQL Advantage, isql.
C:/Sybase/BIN/isql.exe.

notepad ++ NppExec isql.

:

• Notepad ++
• → → →
• , NppExec
• "", - Notepad ++
• SQL script
• F6 (NppExecs )

• - :

  c:/Sybase/BIN/isql -U yourUser -P secret -S yourDB -i$(CURRENT_DIRECTORY)\$(FILE_NAME)

C:/Sybase/BIN isql. isql PATH, :

  isql -U yourUser -P secret -S yourDB -i$(CURRENT_DIRECTORY)\$(FILE_NAME)

8. script OK .

If you save the script, it will save your password in a file; you may not want to do this ... You can leave the password field blank when saving the script, and then add the password before starting it. Just don't save the password in the script file if this is the problem for you (which should be).

When you run an external command (isql in this case) Notepad ++ displays the output in the console window.

Caution: Notepad ++ may have problems displaying millions of records.