Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Benefits of switching from SQL Server to Versant OODB

What benefits (if any) to the company (not only to developers) I could gain by switching from SQL Server 2008 to Versant OODB?

More info about the project and facts to help with an answer (let me know if you need more):

  • Very small team, almost never used OODB.
  • Project uses NHibernate 2.
  • About 75% test coverage.
  • ASP.NET MVC app.

At this stage I could not justify the switch due to following points (most related to db4o, not Versant mainstream OODB):

  • tooling is pretty bad comparing to RDBMSs world where there are bunch of "Managers", profilers, integration/migration tools and others;
  • documentation is pretty basic from what I can observe and heavily mixed with Java;
  • not so many resources on the net comparing to RDBMS;
  • switching to other databases may be problematic (as opposed to RDBMS);
  • learning curve for the developers and IT team;
  • additional licensing cost;
  • additional maintenance cost;
  • no integration with MSDeployment (including automatic backups, MSBuild, Packaging etc);
like image 768
Dmytrii Nagirniak Avatar asked Nov 29 '22 17:11

Dmytrii Nagirniak


1 Answers

Depends on you object model. If you're dealing with a deep object graph in your domain with complex hierarchical relationships you'll benefit big time by switching from SQL Server 2008 to Versant ODB. If you're dealing with flat objects sticks to a relational engine. Please check the c/s results in www.polepos.org: http://polepos.sourceforge.net/results/PolePositionClientServer.pdf

like image 172
German Avatar answered Dec 09 '22 14:12

German