MS SQL vs H2 database

Can I get some feedback on H2 database?  How is the performance vs MS SQL? What are the drawbacks on it?
chaochengaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joseph HornseyPresident and JanitorCommented:
Can you be a little more specific as to what the application is?

I can give you some reasons why I prefer MS SQL over any open source (including H2 or MySQL):

1. MS SQL is incredibly, amazingly powerful.  (Downside - MS SQL can be incredibly, amazingly expensive)
2. MS SQL is extremely easy to develop in; especially if you're used to using GUI instead of command line.
3. There is TONS of support available online
4. There are TONS of books available via amazon.com or at one of the big bookstore chains
5. It's easy to install
6. Did I mention that it's easy to develop in?  The new management console in 2005 is wonderful.

I know that it's trendy to bash Microsoft and talk about how wonderful open-source is, but I totally disagree.  MS SQL is the way to go, especially if this is something new for you.  If you're a beginner, it's going to be hard enough just getting your code to work well.  You're not going to want to spend the time worrying about how to get the database up and running.

Just my opinion.

<-=+=->
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chaochengaAuthor Commented:
I have never seem H2.  So, it is mostly commands instead of GUI? It does not have something like the Enterprise Manager like MS SQL to manage dbs?
0
Joseph HornseyPresident and JanitorCommented:
I don't know if it does or not, and a quick Google didn't show much.  My experience with open source DBs is primarily with MySQL, for which there are a couple of GUIs.  But, hands-down, Microsoft SQL Server has the absolute best GUI for management.  What's really nice is the management console for SQL 2005 is basically a Visual Studio shell.  They've integrated the Query Analyzer and development tools right into the console.  I love it; it's made development so much faster.

Development for me is not something that's incredibly easy; I'm pretty much an intermediate programmer, if that.  So, I don't have time to worry about which build of this I'm using and what build of that.  Or whether this module is dependent on this other thing over there.  Oh, and did you install Perl?  (Or whatever).

Also, I'm a MCDBA, so I'm used to MS SQL.  I'm the first to admit that I'm totally biased about this.  :)

<-=+=->

0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

chaochengaAuthor Commented:
I googled it too and couldn't really find whole lot of info about it.  What about backups?  Does it actually tun on 2003 server?
0
Joseph HornseyPresident and JanitorCommented:
According to the system requirements, H2 runs on XP.  It looks like it's geared more towards running embedded apps than client/server apps.

<-=+=->
0
chaochengaAuthor Commented:
Any H2 experts out there?  Someone that has used H2 before?  
0
Joseph HornseyPresident and JanitorCommented:
Sorry that I'm the only one responding... however, that alone should give you an idea of the level of support you'll receive using H2.  I'd stay away from it, I think.

<-=+=->
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.