On M$ SQL Server and IIS?

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

ep_admin
Posts: 1
Joined: Tue Nov 30, 2010 10:06 pm

On M$ SQL Server and IIS?

Post by ep_admin » Tue Nov 30, 2010 10:25 pm

Does OpenEMM work on SQL Server or IIS?

My IT department is Windows-centric, so we have an easier time getting SQL Server / IIS apps authorized.

Thanks
Gerald

maschoff
Site Admin
Posts: 2165
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff » Wed Dec 01, 2010 6:38 pm

No.
OpenEMM Maintainer

unico
Posts: 4
Joined: Mon May 23, 2011 10:15 am

Re: On M$ SQL Server and IIS?

Post by unico » Mon May 23, 2011 10:20 am

We'd like to use MS SQL Server as our backend for OpenEMM. We reserved some time to try to get this working. How difficult would it be? Are there any show stoppers in principle?

maschoff
Site Admin
Posts: 2165
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: On M$ SQL Server and IIS?

Post by maschoff » Mon May 23, 2011 1:32 pm

OpenEMM does not work with MS SQL Server, only with MySQL.
OpenEMM Maintainer

unico
Posts: 4
Joined: Mon May 23, 2011 10:15 am

Re: On M$ SQL Server and IIS?

Post by unico » Mon May 23, 2011 7:05 pm

I understand that it does not currently run out of the box with anything but MySQL and that you don't provide support for MS SQL Server. But since it is an open source project, outside contributors could try to modify the code to make OpenEMM work with a different database right? So that's what my question related to. How much effort do you estimate this would be? How deep does the tie-in with MySQL go?

Seeing that the Java part of OpenEMM uses Hibernate, my hope is that this part is merely a question of switching to a different SQL dialect. The python part could be more involved however.

I work for an open source company myself that is actively involved with many other open source projects. Once we have OpenEMM working together with MS SQL Server we will be glad to donate back the code.

maschoff
Site Admin
Posts: 2165
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: On M$ SQL Server and IIS?

Post by maschoff » Tue May 24, 2011 7:09 am

OpenEMM's code does not only use Hibernate but Spring's JDBC Templates as well. Moreover, we have JSPs accessing the database directly via custom tags (however, we are refactoring this code right now). So, my hunch is that porting OpenEMM to a different database is a significant effort because you have to manually check all SQL statements or check the log for SQL errors.

How to introduce support for another database will be clear, however, if you have a look at the DAO layer, since some classes are already prepared to support Oracle (for our commercial product).
OpenEMM Maintainer

xmarin
Posts: 1
Joined: Thu Feb 28, 2013 5:22 pm

Re: On M$ SQL Server and IIS?

Post by xmarin » Thu Feb 28, 2013 5:25 pm

Hi!
i need install openem with SQLServer, anyone has a good idea or any example??

Thanks!

Post Reply