Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2006
    Posts
    15

    Unanswered: Transact SQL Editor

    Hello,
    Is there a better SQL Editor than the Sybase SQL Advantage, specially to work on Sybase Stored Procedures.
    It seems to be that there must be something better out there to create/edit stored procedures and run SQL code...
    Thanks,
    Emilio

  2. #2
    Join Date
    Mar 2007
    Posts
    1
    Hi,
    I think CAST SQL-Builder would be better choice than the SQL-Advantage.
    It's an powerful and user friendly IDE .

    for more details about CAST SQL-Builder ,

    http://www.castsoftware.com/resource...QL_Builder.htm

  3. #3
    Join Date
    Mar 2007
    Posts
    25
    Hi Emilio,

    You can also use Rapid SQL.

    For more details about Rapid SQL

    http://www.embarcadero.com/products/...user_guide.pdf

    Regards,
    Poornima.

  4. #4
    Join Date
    Mar 2007
    Posts
    86
    Quote Originally Posted by Malachi4
    Hello,
    Is there a better SQL Editor than the Sybase SQL Advantage, specially to work on Sybase Stored Procedures.
    It seems to be that there must be something better out there to create/edit stored procedures and run SQL code...
    Thanks,
    Emilio
    There are 2 I keep around

    ASE ISQL .. small footprint .. nice to carry around on a util disk .. simple install .. excellent sqladvantage replacement, and much better
    http://dm.char.com.ua/ase/aseisql.htm

    DB Visualizer .. full featured db environment .. platform independant
    http://www.dbvis.com/products/dbvis/

    Aqua Data Studio (v4.7 is free)
    http://www.aquafold.com/downloads.html

  5. #5
    Join Date
    Nov 2006
    Posts
    15
    Thanks for your help!!
    I've got the DB Visualizer, it's a great sql/stored procedure application, easy to use application.

  6. #6
    Join Date
    Mar 2007
    Posts
    86
    and it's free too!!!

  7. #7
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Rapid SQL is the xxxxxx product that your money buy.

    each "x" above means bad.

    Although DBArtisan from the same vendor is much more stable and not as buggy as rapid sql. The funny thing is, Rapid SQL is a cut down version of DB Artisan, obviously when they cut it down they chopped a lot more code than they needed to.

  8. #8
    Join Date
    Mar 2007
    Posts
    86
    Quote Originally Posted by willy_and_the_ci
    Rapid SQL is the xxxxxx product that your money buy.

    each "x" above means bad.

    Although DBArtisan from the same vendor is much more stable and not as buggy as rapid sql. The funny thing is, Rapid SQL is a cut down version of DB Artisan, obviously when they cut it down they chopped a lot more code than they needed to.
    I don't use Rapid SQL .. I never did. I've used all of the CAST workbench products, but their licensing scheme is annoying for most. I always have a copy of DBArtisan installed. For Sybase, DBArtisan is the DBA gold standard.

    My intention was to give the poster access to decent freeware as a replacement for SQL Advantage (what he asked for). The two products I posted are the ones I've found which do the job, are easy to install, use little resourves and cost nothing. When I need to work on a users machine I don't have time to configure a sophisticated software product, and often they have limited disk and memory resources .. I just slap in whatever gets the job done, and remove it when I'm finished.

    As a production support DBA I always use the best I can buy. But, I still use ASE ISQL when I have to .. it has a small footprint and on citrix remote across a slow network that can sometimes make a difference over more graphic tools.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •