RE: Migrating from IBM Universe to mySQL

2005-06-14 Thread Logan, David (SST - Adelaide) 
Hi Rahul,

There are ODBC drivers that you could use, also you may like to look the
BCI and/or UCI interfaces. If you can flatten the data (eg. no
multivalues) you could put the lot into a Type 1 or Type 19 file and
then load the data as required.

You could also just create an I descriptor to get the data from the
various tables you need to extract and plonk the lot into a CSV type
file in a Type 19 directory and then LOAD the data into MySQL that way
(very similar to how you would extract for an Excel file).

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax


-Original Message-
From: Rahul Bollampally [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 15 June 2005 6:31 AM
To: mysql@lists.mysql.com
Subject: Migrating from IBM Universe to mySQL

Hi,

Has any body migrated an IBM's Universe database to mySQL if so 
could you guys please help me out, I need to migrate a huge dataset in 
Universe to mySQL to generate an analysis report.

Rahul :-\


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migrating from IBM Universe to mySQL

2005-06-14 Thread Karam Chand 
Hello,

I guess IBMs Universe Database will be having an ODBC
interface. Then you can use a GUI like SQLyog
(www.webyog.com) to do an ODBC Import from IBMs
database to MySQL.

Regards,
Karam

--- Rahul Bollampally <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> Has any body migrated an IBM's Universe database to
> mySQL if so 
> could you guys please help me out, I need to migrate
> a huge dataset in 
> Universe to mySQL to generate an analysis report.
> 
> Rahul :-\
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 




__ 
Yahoo! Mail 
Stay connected, organized, and protected. Take the tour: 
http://tour.mail.yahoo.com/mailtour.html 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Migrating from IBM Universe to mySQL

2005-06-14 Thread Rahul Bollampally 

Hi,

Has any body migrated an IBM's Universe database to mySQL if so 
could you guys please help me out, I need to migrate a huge dataset in 
Universe to mySQL to generate an analysis report.


Rahul :-\


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]