|
Home > Archive > MySQL ODBC Connector > January 2006 > Type conversion from Mysql to Oracle
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Type conversion from Mysql to Oracle
|
|
| Xiaobo Chen 2006-01-31, 9:23 am |
| Hi, folks
I am trying to convert some Mysql database into Oracle. But their types
are not exactly match. Could any one give a hint?
Thanks in advance!
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
|
|
| SGreen@unimin.com 2006-01-31, 9:23 am |
| --=_alternative 0051C1AD85257107_=
Content-Type: text/plain; charset="US-ASCII"
"Xiaobo Chen" <xiaobo@cs.dal.ca> wrote on 01/31/2006 09:45:00 AM:
> Hi, folks
>
> I am trying to convert some Mysql database into Oracle. But their types
> are not exactly match. Could any one give a hint?
>
> Thanks in advance!
>
> Xiaobo
>
>
> --
> Faculty of Computer Science
> Dalhousie University
> Halifax, Nova Scotia
> Canada
>
>
Here are links to nearly everything there is to know about MySQL data
types:
http://dev.mysql.com/doc/refman/4.1/en/data-types.html
http://dev.mysql.com/doc/refman/5.0/en/data-types.html
Since I know next to nothing about Oracle data types, I am unqualified to
help you to draw any comparisons between the system you are migrating from
and whichever version of MySQL you may be migrating into. If you had been
more specific about the versions you are using, the techniques you are
using to migrate the data, the errors you are having and the results you
expected, you could have received a much more detailed answer.
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0051C1AD85257107_=--
| |
|
|
| Xiaobo Chen 2006-01-31, 11:23 am |
| Hi, folks
First thank all you who replied to my question. I should be more specific
with my question.
In mysql database table, there is some thing like in the 'create table
syntax':
fieldname enum('yes','no') default null
and
fieldname datetime default null
I have no idea about the first one. For the second, I am not familiar with
the 'DATE' type in Oracle and its formatting. In the Mysql table, the
format is like 'YYYY-MM-DD HH:MN:SS'.
What I am doing is trying to duplicate all those tables from Mysql
database into the Oracle database and I am trying to do that by writing a
small java program. The issue I am facing now is that I need to get
correctly the 'create table syntax' for Oracle and trying to keep the
formats of each column as close as possible to that in the Mysql table.
I couldn't find a FREE tool to do this from Mysql to Oracle (not the other
direction). So I decided to write it up.
Thanks again.
Xiaobo
> Hi,
>
>
> What types do you need to convert?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www. databasedevelopmentf
orum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=xiaobo@cs.dal.ca
>
>
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Martijn Tonies 2006-01-31, 11:23 am |
| Hi,
> First thank all you who replied to my question. I should be more specific
> with my question.
>
> In mysql database table, there is some thing like in the 'create table
> syntax':
>
> fieldname enum('yes','no') default null
>
> and
>
> fieldname datetime default null
>
> I have no idea about the first one.
ENUM is a MySQL specific type. I suggest you use a single
char in Oracle: CHAR(1) CHECK (VALUE IN ('Y', 'N') )
or a 3-char, value in 'YES', 'NO'.
>For the second, I am not familiar with
> the 'DATE' type in Oracle and its formatting. In the Mysql table, the
> format is like 'YYYY-MM-DD HH:MN:SS'.
Formatting is - largely - a client side issue.
> What I am doing is trying to duplicate all those tables from Mysql
> database into the Oracle database and I am trying to do that by writing a
> small java program. The issue I am facing now is that I need to get
> correctly the 'create table syntax' for Oracle and trying to keep the
> formats of each column as close as possible to that in the Mysql table.
>
> I couldn't find a FREE tool to do this from Mysql to Oracle (not the other
> direction). So I decided to write it up.
Well, our database developer IDE "Database Workbench" can do
a lot of this, for you - www.upscene.com - but it doesn't come for
free.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www. databasedevelopmentf
orum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|