I would like to explore using MySQL as the RIS database. NHibernate supports MySQL, but I read in other posts about the need for a "driver" in clear canvas.

Can please someone elaborate on this, or point me to the thread that discusses this in detail?

 

Thanks!

I believe any discussions about the need for a "driver" are in regards to the ImageServer and not the RIS. In theory the RIS should work with mySql out of the box, although no one has ever tried this. Also the code that generates the database schema (namespace ClearCanvas.Enterprise.Hibernate.Ddl) will probably need to be modified to support the mySql dialect.

Thanks!

From the MySQL migration page, one of the important differences between MSSQL and MySQL is the capacity of various data types: for example, size of varchar is  4000 for MSSQL and 256 for MySQL.

Would this be an issue for the RIS?

 

Also, I am curious about the Image Server "driver", but I couldn't find the thread discussing this in detail.

 

 

Yes, there's a good chance that a varchar size limitation might be a problem for the RIS. But again, we've never actually tried it.