Re: Migrating from IBM Universe to mySQL
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]
RE: Migrating from IBM Universe to mySQL
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]