On Tue, 26 Feb 2008, [EMAIL PROTECTED] wrote: > Hi Jess,
Hi Wolfgang! > just by chance I had a need to get some Oracle tables into an MySQL Table > yesterday and today I read your proclamation of SQL::Translator ion the > DBIx::Class Mailing List. > > I investigated a bit this morning and installed the package. It seemed to > work on a small MySQL Database for a test, but as I started it for a large > Oracle Database this morning it broke after about 3/4h with the following > message: Heh, what's a "large" database exactly? > Error: translate: Error with parser 'SQL::Translator::Parser::DBI': Can't > call method "add_field" on an undefined value at > /usr/local/share/perl/5.8.4/SQL/Translator/Parser/DBI/Oracle.pm line 78. Thanks for that report, it's somehow failed to create an SQL::T internal table object, and thus cannot continue. It would be nice if it gave you a useful error though ;) If you would like to see why, try adding an "or die $schema->error" on the add_table call in Parser/DBI/Oracle.pm. > My problem is maybe, that I haven't got administrative rights on the > database itself. > > But anyway this problem is not the reason for writing. > > I would like to ask, if there is a possibility to just extract DLL for > only a few tables in the database and not the whole lot. A single table > would be a good solution for me. > > Perhaps I overlooked some of the features of SQL::Translator, but I am > very new to the package and could not find an appropriate spot to look for > it. > > Perhaps a feature like this might be a candidate for the next release? Yes, that would be a great idea. Ideally there should be a parameter for all parsers and producers to only input/output a certain list of objects. I don't think anyone is working on this, so would you like to send us a patch? Jess ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
