Rails - Dec 2005 - Newbie : Access - Rail , Sqlite combo

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


_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails

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...
> 2) 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.
> 3) 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...

-- 
Posted via http://www.ruby-forum.com/.

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.
>
> > 2) 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
>
> > 3) 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
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>