Augusta ENT wrote:
We have very few sql statements in the app. We can change them very quickly to match Mysql or H2. Unless you know of something very strange in H2 the switch to H2 should be very easy. We did have this app running in Access before we changed to SQl Server a year ago the the upgrade took about a hour.
Another of H2's great features is the ability to emulate other databases. So if you've written your app for a particular flavor of SQL, let's use SQL Server as an example, you can just set the mode of H2 to be SQL Server and it will use SQL Server's flavor of SQL.
I'm sure there's some tweaks involved in some cases, but you can set H2 to emulate Derby, HSQLDB, Oracle, SQL Server, MySQL, and PostgreSQL, and H2 also has its own native mode.
If you've written your app targeting Access, chances are you'll want to give SQL Server mode a shot (although there are differences between SQL Server and Access of course), or if your queries are pretty simple it might "just work" without any changes.
You'll definitely want to test. ;-) I'll send that other email outlining all the H2 configuration shortly. -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com/blog Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html
smime.p7s
Description: S/MIME Cryptographic Signature
