We are doing something very similar right now. We have a MS SQL server
with an Access VBA front-end that we are transitioning to a Rails/MySQL
setup. It is working very well so far…
- how to export data from access file to sqlite db file.
Not exactly sure here, but can relate our experiences with SQL. We are
using the data transformation services to export to unicode CSV files
that we then import into MySQL. This makes sense for us because we are
tweaking the naming of our tables and columns to line up with rails
I would take a hard look at MySQL or PostgreSQL instead of SQLite in
your situation. Sounds like you need a full featured DB…
- In rails how easy is to export some data to excel and report to pdf
Others will have to weigh in here, but I know both are possible.
- my idea of moving from desktop application to web based application
going to work or not.
It’s working great for us, no more need for every computer to have
Access, better user authentication, remote access, not to mention a lot
more control over our development process…