Newbie : Access - Rail , Sqlite combo


#1

We have our company database in access and also front end in access-vba.
now I’m planning to move that database to sqlite and want to create
front
end in rails+ajax
(main cause for this move is freedom from OS dependence for end user )

pls advice on following

  1. how to export data from access file to sqlite db file.
  2. In rails how easy is to export some data to excel and report to pdf
    file
  3. my idea of moving from desktop application to web based application
    is
    going to work or not.

Regards
Niket


#2

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…

  1. 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
conventions.

I would take a hard look at MySQL or PostgreSQL instead of SQLite in
your situation. Sounds like you need a full featured DB…

  1. In rails how easy is to export some data to excel and report to pdf
    file

Others will have to weigh in here, but I know both are possible.

  1. my idea of moving from desktop application to web based application
    is
    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…


#3

thanks for quick answer… rails already has gr8 community.

  1. 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
conventions.

exporting to CSV is done. now how to import data in sqlite??

I would take a hard look at MySQL or PostgreSQL instead of SQLite in
your situation. Sounds like you need a full featured DB…

I had a look at mysql(also done importing of my data and build a
sample application with use of mysql) but as per our situation sqlite
will work fine. and I’m very new to sqlite.

  1. In rails how easy is to export some data to excel and report to pdf
    file

Others will have to weigh in here, but I know both are possible.

ok

  1. my idea of moving from desktop application to web based application
    is
    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…

noted. and I will work hard to achive the better usability than access
project.
pls add more views.

Regds
Niket