Porting is always a pain to handle. What you are asking is more of an architecture based question than a H2 specific question but it's welcomed.
What is your Windows application programming language made of ? Is it MS .NET based ? Java ? Python ? C / C++ ... If you want to make your database accessible via Windows and Mac, you can go MySQL, SQLite, H2, Postgres ... all these are good databases that can be found across Windows, Mac and Linux. Their licenses are open source as well. How do you define quickest / least effort to port a platform specific (MS Access) database to something you expect to run across Windows and Mac or more platforms ? Some solutions you might want to use is to make your variable types in the MS Access database friendly to MySQL, SQLite, H2 .. preferably via standards like the SQL92 standard despite these standards not always that solid. What you need to do is to use common formats and variable types for the table design in the database and then export them in SQL or better, CSV format from the MS Access. When your application runs in Mac using non-Access db, you can use the SQL script or CSV to import them in for use in Mac environment. I would strongly recommend that you move away from using MS Access as your database if you want to have a cross-platform application that can execute on Windows or Mac. Something like MySQL or SQLite would suit. Maybe Postgres ? If you application is Java-based, then H2 is a very good option. To answer your question if H2 is a good candidate, I think you need to provide more information and scenarios for a clearer picture before a better recommendation could be given. Please give more information. On Nov 27, 5:47 am, justaguy <[email protected]> wrote: > Hi, > > I've decided to port my current app to support Mac as well. > Currently, the off-line app supports Windows OS only because it's > back- > end data storage vehicle is MS Access. > > There seems quite a few options out there... and I've eliminated a > few > of them already including mySQL... > > A couple of things stand out here... > a) quickest / least effort to port the Access db to its equivalent or > the like for Mac > b) the new database would have to be accessible by Railo on Mac, that > is, via a datasource > c) this new database on Mac platform is free, hence, I can bundle it. > > Would H2 be a good candidate for this? Thoughts? > > Thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
