Equivalent of JChem Cartridge for SQL Server?

Hopefully a quick, basic question; I have just been given the task of evaluating if an existing Marvin-based ASP.NET drawing/editing/searching application can be converted from using an Oracle back-end db to SQL Server. I see that there are a number of Oracle functions included in a jchem_cart.sql file. My basic question is if there is a SQL Server equivalent already in existance, or if I will have to try and convert all of these functions, etc. myself? Thanks very much.

The jchem_cart.sql file is part of JChem Cartridge. JChem Cartridge is based on Oracle's Data Cartridge technology which is (to my knowledge) not available with Microsoft SQL server.





Currently, you have the following options to use JChem with Microsoft SQL Server:





- Using JChem Base with Java API (http://www.chemaxon.com/product/jc_base.html)


- Using ChemAxon's .NET integration solution(s) (see in particular the ASP.NET example application http://www.chemaxon.com/jchem/examples/ChemAxon.NET/ASP.NET/doc/index.html)





In terms of .NET integration, we currently support JNBridge (http://www.chemaxon.com/jchem/doc/guide/dotnet/index.html) which is a tool to make Java API available to .NET applications. We are also working on releasing JChem in the form of .NET libraries.

We are going to release our JChem API as a .NET dll in January. You will be able to use JChem Base based search with that. However you will have to replace your existing SQL calls with JChem API calls. We could help you with that.





In the future we might investigate the possibility of using CLR functions in SQL Server, in order to provide similar SQL functions as in our Oracle Cartridge.