Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Enterprise Databases?

Options
  • 29-06-2005 8:47pm
    #1
    damnyanks
    Registered Users Posts: 4,276 ✭✭✭


    Howdy,

    Just curious what is the main difference between the likes of Sybase, DB2, Oracle, MS SQL ?

    Can any of the databases do something that hte other cant or is it primarily a pricing / platform issue ?


Comments

  • Options
    #2
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 91,690 Mod ✭✭✭✭Capt'n Midnight


    Don't forget licencing T&C's , MsSQL can be Byzantine, std version may ignore more than 2GB of ram, anything that connects uses a client license or you could get on to the hardware upgrade spiral with a per processsor license. /RANT


  • Options
    #3
    optiplexgx270
    Registered Users Posts: 2,497 ✭✭✭optiplexgx270


    sounds like a job for google mate plenty of info on each out there inc side by sides.


  • Options
    #4
    Merrion
    Registered Users Posts: 1,421 ✭✭✭Merrion


    Sybase and SQL Server 7 are broadly speaking the same thing.

    SQL Server 2000 adds a host of new featured (varchars can be 4000 long rather than Sybase's 256 char max, XML data types, reporting services etc.)

    SQL Server 2005 (still in Beta until November) adds CLR intergration (you can code in .NET directly in the database) proper XML data types with the option to add XSL validation at field level etc.

    I haven't worked with Oracle since V7 so cannot give you advice on it; but it is generally considered to be the best but most expensive option.


  • Options
    #5
    amen
    Registered Users Posts: 2,781 ✭✭✭amen


    Sybase and SQL server 6.5 were more the same
    7 added a bit extra with 200 adding a lot more
    don't forget MySQL
    its free (sort off) and very quick

    why do you need to know ?


  • Options
    #6
    Kernel32
    Registered Users Posts: 640 ✭✭✭Kernel32


    An enterprise database is often defined by its ability to scale. Scale up on processors and memory or scale across in a cluster. I am most familiar with SQL Server and Oracle myself. In very many cases the database of choice within a company has more to do with the person who made the choice and which technology they felt more comfortable with and how good the database vender's sales person is. Those Oracle sales guy often get there foot in the door by selling a package like Oracle EAM or Oracle Financials. Now that the company has Oracle database licenses they build everything on Oracle. At that point its a financial decision.


  • Advertisement
Advertisement