Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    7

    Which DB is the best for my solution?

    Hi,

    We currently use MySQL free edition and I've been tasked to find out which other DB's we should consider such as MS SQL and Oracle.

    In addition I need to know the positives and negatives of each one.

    This database needs to have easy reporting, be fast, reliable and offer the ability for our Java and Matlab users to access it.

    What do you think?

    Thanks

    Josh

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    SQL Server is much simpler to use and administer. It would be my recommendation. Also, Microsoft has made available a migration tool to assist in moving databases from MySQL to SQL Server.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by joshfolgado
    Hi,

    We currently use MySQL free edition and I've been tasked to find out which other DB's we should consider such as MS SQL and Oracle.

    In addition I need to know the positives and negatives of each one.

    This database needs to have easy reporting, be fast, reliable and offer the ability for our Java and Matlab users to access it.

    What do you think?

    Thanks

    Josh
    It's difficult to answer your question without knowing what skills you have - for instance it would be pointless recommending Oracle if you don't have any experience with Oracle. Do you have much experience with the RDBMS you're currently using (MySQL)?

    I've worked my way through all your questions this morning and feel that at the end of the day your employers have given you a set of questions and that they are expecting you to be capable of answering them. If you just pass all their questions to us and then you pass our answers back to your employers then they'll soon figure they hired the wrong guy.

  4. #4
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by joshfolgado
    This database needs to have easy reporting, be fast, reliable and offer the ability for our Java and Matlab users to access it.
    Are your users exclusively Windows-based? SQL Server is Windows only whereas Oracle and others support a range of different OSs.

Posting Permissions

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