[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1957
  • Last Modified:

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?
0
chaochenga
Asked:
chaochenga
  • 4
  • 3
1 Solution
 
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
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now