views:

1276

answers:

12

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
+1 for Embarcadero. Pricey but I like it better than SSMS.
TrickyNixon
A: 

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

AlanR
How about a pass-through query on MS-Access?
ConcernedOfTunbridgeWells
As an alternative, you could see if there's an open-source DB frontend on Sourceforge.
ConcernedOfTunbridgeWells
You should also edit your question to make this clear.
ConcernedOfTunbridgeWells
+1  A: 

Have you looked at ASE ISQL?

Paul Owens
+1 to that - it's what I used until I managed to get out of Sybase-related jobs (happy days)
Mike Woodhouse
+1  A: 

SQL Anywhere.

AlanR
Add a link please. Many things are called "SQL Anywhere". Sybase embeded db for example.
Oleksandr Bolotov
SQL Anywhere is database software in and of itself, not a management tool like he's asking for. -1
Zerofiz
A: 

sql dbx has grid view

A: 

+1 for sql dbx

A: 

Give WinSQL a try, it's great!

B0rG
A: 

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

msiemeri
+1  A: 

Take a look at QweryBuilder

Zerofiz
A: 

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
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
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
A: 

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
A: 

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