Hi.
I have ran into couple of problems using Oracle workbench migration tool.
I was wondering if anyone out there has any insight.
1. If a date field in a mysql table has a default (let's say 9999-12-31)
the script for oracle table will also have 9999-12-31 as a default field.
This doesn't seem to work in Oracle because Oracle expects to see
something like to_date('9999-12-31','yyyy-mm-dd'). I couldn't find a way
to modify that in the Workbench.
2. If a numeric field is defined in the mysql database as smallint,
the workbench creates a corresponding Oracle field as num(250),
while oracle would expect the presicion no more than 38. Again,
I couldn't find a way to fix it in the workbench.
3. If I'm attempting to modify a oracle field's parameters in the workbench,
it won't let me to move to another table without asking "do you want
to save the changes" and won't move on unless I click on "No".
I would appreciate any comments on these issues
tia
AOD
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
