Hi Ben, Thanks for the reply. I am trying to do the following.
1. I have a database (Can be Oracle, MySql, Access) source from where I can get the ddl of a table. 2. I can write the ddl into an XML format. (The format is defined by steps 4 and 5) 3. I want to feed the xml to your procedures. 4. I want to get an output (a create statement) based on my flags. 5. My flags will say if I need the output for Oracle, MySql...etc. Essentially when I dump data from a database, I want a tool to help me build the create statement and load script for the destination database. I downloaded SQL-Translator-0.09000 into my HP-UX box. I got the following errors. Please guide me set up. > perl Build.PL Checking whether your kit is complete... Looks good Checking prerequisites... * Optional prerequisite Text::RecordParser is not installed * Optional prerequisite GraphViz is not installed * Optional prerequisite Spreadsheet::ParseExcel is not installed * Optional prerequisite Template is not installed * Optional prerequisite XML::Writer is not installed * Optional prerequisite XML::XPath is not installed * Optional prerequisite Graph::Directed is not installed * Optional prerequisite IO::Scalar is not installed - ERROR: Test::Differences is not installed - ERROR: Test::Exception is not installed - ERROR: YAML is not installed - ERROR: Class::MakeMethods is not installed - ERROR: Class::Data::Inheritable is not installed - ERROR: Class::Base is not installed - ERROR: Log::Log4perl is not installed - ERROR: Parse::RecDescent (1.80) is installed, but we need version >= 1.94 - ERROR: Class::Accessor::Fast is not installed ERRORS/WARNINGS FOUND IN PREREQUISITES. You may wish to install the versions of the modules indicated above before proceeding with this installation Deleting Build Removed previous script 'Build' Creating new 'Build' script for 'SQL-Translator' version '0.09000' Now run './Build', './Build test', and './Build install' -----Original Message----- From: Ben Faga [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2008 12:21 PM To: Venkatesan, Muralishankar (EX1 - Plymouth Meeting) Cc: sqlfairy-developers@lists.sourceforge.net Subject: Re: [sqlfairy-developers] FW: Help please. Hi Murali, I'm not sure if anyone is going to volunteer for to that level of support (although ++ to anyone who does). However, please email the list with the problems that you are having (including what you've done and the error messages). You are likely to get good help (there are some very bright people who read this list) and it will be useful for anyone else who is having the same issue as you. Thanks, Ben On Tue, 2008-03-04 at 14:12 -0500, [EMAIL PROTECTED] wrote: > Hi, > Is there anyone to whom I can talk over phone and get the > installation problems resolved. I am trying to install in HP-UX. > > Thanks > Murali > > -----Original Message----- > From: Darren Chamberlain [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 04, 2008 12:23 PM > To: Venkatesan, Muralishankar (EX1 - Plymouth Meeting) > Cc: sqlfairy-developers@lists.sourceforge.net > Subject: Re: FW: Help please. > > There is no sqlfairy.xml: it's a virtual URI, used only to identify > the namespace. You have to take a look at the > SQL::Translator::Producer::XML::SQLFairy docs > (http://search.cpan.org/dist/SQL-Translator/lib/SQL/Translator/Produce > r/ > XML/SQLFairy.pm) > for what it tastes like. > > I haven't looked at the XML in years, but I seem to recall that it's > fairly straightforward and self-explanatory, if you already know SQL. > Take a closer look at your example: > > <field name="title" is_primary_key="0" is_foreign_key="0" > size="100" is_auto_increment="0" data_type="varchar" > order="2" default_value="hello" is_nullable="0" /> > > Given that this is describing a field in a database table, all the > attributes seem clear to me. > > (darren) > > * Murali Venkatesan <MVenkatesan at us.imshealth.com> [2008/03/04 > 10:19]: > > Please help. > > > > Thanks > > Murali > > > > ________________________________ > > > > From: Venkatesan, Muralishankar (EX1 - Plymouth Meeting) > > Sent: Tuesday, March 04, 2008 10:17 AM > > To: '[EMAIL PROTECTED]' > > Subject: Help please. > > Importance: High > > > > > > Hi, > > I am trying to install the application SQL Fairy in a HP-UX > > environment. I am having issues getting past the first steps itself. > > Is there a phone where I can call. Also I need to know the details > > on http://sqlfairy.sourceforge.net/sqlfairy.xml. > > <http://sqlfairy.sourceforge.net/sqlfairy.xml.> > > > > > > ________________________________ > > > > From: Venkatesan, Muralishankar (EX1 - Plymouth Meeting) > > Sent: Monday, March 03, 2008 12:14 PM > > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > > Subject: Rules Please. > > > > > > Hi Mark, > > Can you please let me know the details of the namespace in > > > > http://sqlfairy.sourceforge.net/sqlfairy.xml. > > > > > > I am not able to download the xml. I wish to know the names of the > > tags and what they represent. In Short please let me know the > > mappings > > > (and > > domain) for the attributes in red below. > > > > > > <field name="title" is_primary_key="0" is_foreign_key="0" > > size="100" is_auto_increment="0" data_type="varchar" > > order="2" default_value="hello" is_nullable="0" /> > > > > Thanks > > Murali > > Ext 4432 > > > > > > Thanks > > Murali > > Ext 4432 > > > > -- > The Feynman Problem Solving Algorithm: > 1) Write down the problem. > 2) Think real hard. > 3) Write down the answer. > > ---------------------------------------------------------------------- > --- 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/ ------------------------------------------------------------------------- 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
