SubSonic and SQL

[centuryx476]

Hello,
I am using Subsonic on Windows. My entire infrastructure is Windows based.

I have Subsonic installed on a Windows 10 VM.

My question is how can I make it so that Subsonic can use SQL as the back-end? I cannot really find any tutorial on how to do this for a Windows based machine
In addition is their any performance advantage to using SQL or mySQL as the back-end for subsonic ?

Thank You

[acroyear]

Subsonic uses HSQL as its DB, an embedded database that is all Java. While it and other DBs like SQL Server and MySQL are all SQL-92 compliant, there are often little tiny differences, usually around how indexes or foreign keys are defined, or in stored procedure syntax, such that it isn't necessarily possible to just drop-in a different SQL engine without some changes in the code. This would then make upgrading to new releases very difficult.

As for performance, all things depend on the size of your database, but I don't think in the mere thousands of records that it would make that big a difference.

[centuryx476]

Thank you for the info.

But if one were to try and setup subsonic with SQL. Just for fun and practice.

How would you do it?

[acroyear]

With 6.0 now being closed-source (as I just read), it is not possible to do it. You won't have access to the necessary source codes to make any required changes.

With the 5.3, you'll need to get the source code and all the tools required to build it (like Maven), plus a full JDK, and an editor like Eclipse or Netbeans. Then grab the JDBC driver for SQL Server from Microsoft's MSDN. Then find in the code and possibly the config files where the DB is initialized and its driver declared and change that to point to the SQL Server one. Then build it, figure out how to deploy it, start it up and watch the error log for all of the failures. Then fix each one, wipe out the DB created up to that point, and repeat.

Nothing hard, but tedious and sometimes painfully frustrating for the little differences. I don't see it as worth the effort.

[centuryx476]

Well then, Since it is now closed source.
I guess I can write that off then as a project.




Thank You very much for the info...