What's a good front end query tool for SYBASE?

views:

1276

answers:

+3 Q:

What's a good front end query tool for SYBASE?

Good morning,

I've had enough of the text-only editor.

Is there a SQL Management Studio-like sql editor for SYBASE? I can't imagine people work with the text editor -- makes me want to pull my teeth out.

I couldn't get SQL Management Studio to work with it. No dice with visual Studio 2008 either.

Thanks, -Alan.

+1 A:

Some options:

Embarcadero RapidSQL - probably the tool of choice for Sybase SQL development.

Quest TOAD for data analysts - this is not the traditional TOAD product but is a managed code .Net application that appears to be based on the Visual Studio framework. It will connect to (presumably) anything that speaks ODBC, including Sybase. Performance and memory usage is what you would expect of a managed code application, but it does work with Sybase.

ConcernedOfTunbridgeWells 2009-01-09 15:07:59

+1 for Embarcadero. Pricey but I like it better than SSMS.

TrickyNixon 2009-01-09 15:10:27

These cost a lot. I'm looking for something simple and free. Anything that at least puts the results into a grid.

AlanR 2009-01-09 15:18:36

How about a pass-through query on MS-Access?

ConcernedOfTunbridgeWells 2009-01-09 16:14:56

As an alternative, you could see if there's an open-source DB frontend on Sourceforge.

ConcernedOfTunbridgeWells 2009-01-09 16:17:11

You should also edit your question to make this clear.

ConcernedOfTunbridgeWells 2009-01-09 16:17:55

+1 A:

Have you looked at ASE ISQL?

Paul Owens 2009-01-09 17:26:34

+1 to that - it's what I used until I managed to get out of Sybase-related jobs (happy days)

Mike Woodhouse 2009-01-09 17:54:49

+1 A:

SQL Anywhere.

AlanR 2009-01-12 18:57:34

Add a link please. Many things are called "SQL Anywhere". Sybase embeded db for example.

Oleksandr Bolotov 2009-04-21 07:53:49

SQL Anywhere is database software in and of itself, not a management tool like he's asking for. -1

Zerofiz 2009-06-12 17:17:36

sql dbx has grid view

2009-03-29 03:02:34

+1 for sql dbx

2009-04-29 13:19:59

Give WinSQL a try, it's great!

B0rG 2009-06-12 17:08:39

Our company relies on Sybase ASE a lot. Many developers, me included, use Squirrel SQL. Look here.

msiemeri 2009-06-12 17:11:21

+1 A:

Take a look at QweryBuilder

Zerofiz 2009-06-12 17:23:54

Have you tried using Eclipse Data Tools Platform?

You might not need all of Eclipse's functionality, but I personally have been able to easily set up a connection to a Sybase database that I have to pull data from for legacy applications.

This gives you a full powered SQL query window, with results coming to you in a grid-view fashion (just like Management Studio). For a tutorial on how to set it up, check out this tutorial that I found by Googling, except replace MySql with Sybase where you see it, and download the Sybase JDBC driver or use jTDS.

KG 2009-07-15 17:39:28

Sounds very reasonable. However, having migrated to DotNet from Java over a year ago, I only want to download Eclipse 2 seconds before my car hits a propane truck.

AlanR 2009-07-17 20:15:18

Understandable ;-) However, for the cost (free) and amount of features you can't go wrong, even if all you use Eclipse for is your Sybase querying tool.

KG 2009-07-17 21:42:00

dbsolo.com or dbvis.com

I actually paid for dbsolo and I hate paying for anything! It's only $99 and you can use it on all platforms!

SC 2010-05-06 22:39:36

ASI SQL is great, simple and easy to use.. takes up least amount of memory, uses native CT Lib connection, pretty fast as it is C++.. it is FREE TOO !

san 2010-06-27 13:24:26

ansaurus

tags:

views:

answers:

What's a good front end query tool for SYBASE?

related questions