Sybase GUI Client

What are the available Sybase GUI 开发者_如何学Goclients for Windows.

I have tried DBVisualizer and RazorSQL any other recommendations. Free preferred

---

u can try "Interactive SQL" which shipped with Sybase 15 Client, it's better than Sql Advantage, and it's free to download via. Sybase website.

---

One other solution would be sqlDeveloper from oracle (if you are used to it). You can make it work with Sybase databases by downloading the jTDS driver. Then you can go to sqlDeveloper and choose Tools -> Preferences -> Database -> Third Party JDBC driver. It will work like a charm.

I find it very convinient as i was used to sqlDeveloper, so i can add any driver for any DB provider i want.

---

You can try a non commercial client TOAD for sybase and a comercial client like dbArtisan that allows you debug of the stored procedures what for me its very usefull.

---

I like SQL Workbench/J, sort of like DBVisualiser but entirely free. It can connect to a lot of databases (that have JDBC drivers) and has a handy datapump/data replication tool, that can also be used in batch mode.

---

Aqua Data Studio seems popular with the clients I work with. But I generally use the tools from Sybase : Interactive SQL (SQL Editor) and Sybase Central (Data Schema, Debugger etc)

---

Other possible tools could be Squirrel and DBeaver. Both are open-source and free.

Here are some links : dbeaver.jkiss.org squirrel-sql.sourceforge.net .

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

DBeaver will let you do all basic DDL and DML functions, DB object script extraction etc. Various plugins exist e.g DBDiff Plugin which lets you compare objects between two different sessions

---

Workbench/J is a good choice. It can work with Oracle/Sybase/Informix and other databases.

Setup SQL Workbench/J to connect to sybase in Ubuntu 14.0.4

1. Install SCN SDK "https://store.sap.com/sap/cpa/ui/resources/store/html/SolutionDetails.html?pid=0000013451&catID=&pcntry=US&sap-language=EN&_cp_id=id-1417018812660-0"

2. unzip the file.

3. create /opt/sap and chown sap:sap /opt/sap -- sap is the owner for software

4. run setup.bin after unzip the linux.tgz

5. In SQL Workbench Setup jdbc connection pointing to "/opt/sap/jConnect-16_0/classes/jconn4.jar"

6. Setup sybase connection URL to be jdbc:sybase:Tds:: e.g. jdbs:sybase:Tds:sybase1:5000