[Jakarta-pm] Database migration
Christian Maxnamara
christian_maxnamara at hotmail.com
Thu Mar 17 23:30:38 PST 2005
>
>Christian Maxnamara wrote:
>>Hello Cinta,
>>
>>I have about 2 years experience in Perl programming either on Linux or
>>Windows.
>
>I have 8 years of Perl programming experience but only on Linux and other
>Unix platforms. I very rarely do anything with Windows and so haven't had
>much cause to use ActivePerl yet.
>
>>I use Perl to create SMS Quiz processing that connect to MySQL database. I
>>use also to do migration of data from Ms. Access to PostgreSQL.
>
>That sounds quite interesting. With respect to your migrations, have you
>come across any ways to make applications which talk ODBC to be able to use
>Perl's DBI module. I understand that it's possible to write Perl programs
>to use DBI and DBD::ODBC but I've been thinking about writing a plugin
>which would work the other way: some MS program expects to talk to an ODBC
>database and instead can use DBI and DBD::Proxy somehow...
>
I've been using Win32::ODBC to migrate either from Ms Access to PostgreSQL
or Ms Access to SQL Server 2000.
The simplest thing has been done on MySQL, we could just write: use DBI;.
I've ever found also a ASP-like way to include the MDB file for database
connection.
That is a good idea to start to build commercial software for database
migration that built on plugin for various databases and platforms.
>>Perl is lite and powerful.
>>I like it.
>
>Me too.
>
>>Do you have something interesting to do with Perl ?
>
>As I said to Josberto, mostly I teach Perl and writing training materials
>for my courses.
>
>My current project is a bit of fun though. I'm writing an online web
>interface to replace an MS Access form for adding stuff to a database.
>I've only recently discovered Class::DBI and HTML::FillInForm, but between
>them I've already saved about 10 hours! I can highly recommend using these
>modules.
>
>So, what have you been up to recently?
>
>All the best,
>
> Jacinta
>
>--
> ("`-''-/").___..--''"`-._ | Jacinta Richardson |
> `6_ 6 ) `-. ( ).`-.__.`) | Perl Training Australia |
> (_Y_.)' ._ ) `._ `. ``-..-' | +61 3 9354 6001 |
> _..`--'_..-_/ /--'_.' ,' | contact at perltraining.com.au |
> (il),-'' (li),' ((!.-' | www.perltraining.com.au |
>
>
>_______________________________________________
>Jakarta-pm mailing list
>Jakarta-pm at pm.org
>http://mail.pm.org/mailman/listinfo/jakarta-pm
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
More information about the Jakarta-pm
mailing list