On 20 Nov 98, at 8:16, Luana Howard wrote:
> How different is say using the different PERL extensions, Perl::Oracle,
> Perl::SQL, than using DBI?
Warning, I am not an expert on these matters but I have used DBI
rather extensively. You use DBI and then choose the module,e.g.
my $data_source = "dbi:mSQL:okpi";
my $db = DBI->connect($data_source) || die "dbi fail: $@ or $!\n";
You can see that I am using the mSQL module here. And here I use
mysql:
my $data_source = "dbi:mysql:brain";
my $db = DBI->connect("$data_source:localhost",'insert user','insert password') ||
die("Can't connect to $data_source: $DBI::errstr");
I have to give a username and password to mysql.
Now each rdbms may have its own proprietary methods (I believe Oracle
has many). I tend to use only plain vanilla SQL. I can move a
database from mSQL to mySQL in less than half -an- hour (not only
changing the script but exporting and importing but then it will
depend on the size). You can run these commands:
msqldump database > file
and you may then have to massage some of the "data types" and then
just do this:
mysql database < file
But, there is a conversion program that I have not used which I think
will easily convert from msql to mysql.
I would say use DBI.
Peter
> We're using Linux (most recent, stable build), PERL 5.004.x, PostgreSQL
> 6.3, DBI 1.73. We also have NT servers that might be used similarly in the
> future.
>
--------
The enduring goodness of the American military character over the past
two centuries does not automatically derive from our nation's
nutritional habits or from a good job benefits package. This character
must be developed and supported, or it will die.
-By Daniel J. Rabil http://www.wbap.com/marknote/note111298.html
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
