in reply to The need to work and re-train

This might not be to the point of your meditation but if you wanted to spin-up a little on sybase to see how similar it is to other DBMS's you have used. I think that MS's SQLServer is based on Sybase. Well anyways sybase does have free (promo) linux based version http://www.sybase.com/linuxpromo.

Personally I think Sybase is junk but good luck anyways.

Plankton: 1% Evil, 99% Hot Gas.

Replies are listed 'Best First'.
Re^2: The need to work and re-train
by KeighleHawk (Scribe) on Sep 28, 2004 at 21:05 UTC
    As I recall, MS SQL Server was basically a "fork" of either Sybase 4.9.1 or 4.9.2. I would imagine it is still SQL Server under the hood and still uses Transact SQL as it's procedural language for triggers and such as well as retaining the basic concept of databases/schemas, etc. of Sybase.

    Does MS SQL Server have a GUI administration tool? I had thought the main add of MS SQL Server was a GUI tool set and under the hood, it was still much the same.

    Since they are looking (presumably) for a programmer not a DBA and assuming your experience with MS SQL Server is programming in Transact SQL, then you might add Transact SQL T/SQL) to your resume and include in a cover letter that you are "..familiar with MS SQL Server Transact SQL which is similar to Sybase Transact SQL..."

[reply]
      MS SQL Server and Sybase are from the same code base. MS bought the code from Sybase (silly silly move on Sybase's part). Version 6.5 of MS SQL Server was basically Sybase with a GUI, 7 is slighly different and 2000 is even more so. However that said MS has maintained pretty much all the previous interfaces for backward compatibility and to make it easy to migrate from Sybase. :-) If you can get on hands a early version of MS SQL Server you basicall can train yourself on Sybase. :-)
[reply]
      I had thought the main add of MS SQL Server was a GUI tool set and under the hood, it was still much the same.

      Many years ago I used MS SQL Server. It was so similar to Sybase that I was actually *trained* on Sybase. I didn't use a Sybase GUI, but that doesn't mean that there wasn't one, it could have been taken away so we could learn how to do things properly.

      These days, Sybase does indeed have GUI admin tools, at least on Mac OS X, which look almost identical to the ones I was using on NT those many years ago.

      There are free developer licences available for Sybase. Download and play.

[reply]
Re^2: The need to work and re-train
by mpeppler (Vicar) on Oct 02, 2004 at 06:22 UTC
    Personally I think Sybase is junk
    Care to elaborate on that? (maybe in a /msg rather than here, as it's not really relevant, but I'm interested in your opinion)

    Michael

[reply]

    • DB dump files are not useable between different implemenations of Sybase. And there no tool to fix that problem (AFAIK).
    • The installation documentation was all wrong and (IMHO) kludgy.

      Both of these problem where enough to make me use free RDBMS instead of slapping down $2,000 bucks.


      Plankton: 1% Evil, 99% Hot Gas.
[reply]
        Your first point is fixed in 12.5.3 (due out before the end of the year).

        As for the second - I haven't really looked at the install docs in a long time, but I haven't seen any real issues with it. And of course there is a free (as in beer) version for linux...

        And I'll shut up now as this has nothing to do with the original thread...

        Michael

[reply]

In Section Meditations