yes..exactly thats what i am planning to do now. Thank you sujay _____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 7:35 PM To: Sujay Koduri Cc: mysql@lists.mysql.com Subject: Re: Datatype conversion Sujay Koduri <[EMAIL PROTECTED]> wrote on 10/17/2005 06:25:58 AM: > hi all, > > i have a strange problem here. I have around 600 tables in Oracle DB(On 8i, > so i am not able to use mysql migration tool kit!!). Now i want move all of > these to mysql. I am initially trying to convert the schema from oracle to > mysql. My problem is, in the existing oracle DB, for storing both integers > as well as decimal values i am using the same dataype 'number'. But during > migration i want to distinguish if that field 'number' in oracle is actually > holding an integer or decimals. Is this possible to do or i have to manually > do it only. > > Thank you sujay Unless you can somehow extract some additional information about your fields, you will not be able to automate such a conversion. How were you planning to make the decision by hand? You could probably write something to dump your Oracle schema as a MySQL-ready script complete with the numeric data type conversions (based on how you wanted to decide which columns were integers and which ones were not). Then it becomes a simple matter of "playing" that script through the CLI (use the "source" command) to actually create your destination tables. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
