dbTalk Databases Forums  

migrate ORACLE TO SQL

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc migrate ORACLE TO SQL

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss migrate ORACLE TO SQL in the comp.databases.oracle.misc forum.



Reply
Page 1 of 3 1 2 3 >
 
Thread Tools Display Modes
  #1  
Old   
news.free.fr
 
Posts: n/a

Default migrate ORACLE TO SQL - 04-02-2008 , 11:48 AM





Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables,
PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from sql
to oracle.
The datatypes of the source tables (from Oracle) are number, varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping




Reply With Quote
  #2  
Old   
fitzjarrell@cox.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 02:47 PM





On Apr 2, 11:48*am, "news.free.fr" <grill... (AT) yahoo (DOT) com> wrote:
Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables,
PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from sql
to oracle.
The datatypes of the source tables (from Oracle) are number, varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping
ERWin comes to mind.


David Fitzjarrell


Reply With Quote
  #3  
Old   
fitzjarrell@cox.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 02:47 PM


On Apr 2, 11:48*am, "news.free.fr" <grill... (AT) yahoo (DOT) com> wrote:
Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables,
PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from sql
to oracle.
The datatypes of the source tables (from Oracle) are number, varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping
ERWin comes to mind.


David Fitzjarrell


Reply With Quote
  #4  
Old   
fitzjarrell@cox.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 02:47 PM


On Apr 2, 11:48*am, "news.free.fr" <grill... (AT) yahoo (DOT) com> wrote:
Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables,
PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from sql
to oracle.
The datatypes of the source tables (from Oracle) are number, varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping
ERWin comes to mind.


David Fitzjarrell


Reply With Quote
  #5  
Old   
fitzjarrell@cox.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 02:47 PM


On Apr 2, 11:48*am, "news.free.fr" <grill... (AT) yahoo (DOT) com> wrote:
Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables,
PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from sql
to oracle.
The datatypes of the source tables (from Oracle) are number, varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping
ERWin comes to mind.


David Fitzjarrell


Reply With Quote
  #6  
Old   
news.verizon.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 09:55 PM



"news.free.fr" <grille11 (AT) yahoo (DOT) com> wrote

Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB
(tables, PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from
sql to oracle.
The datatypes of the source tables (from Oracle) are number,
varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping



Oracle uses SQL so I don't understand what you are migrating to. SQL stands
for Structured Query Language. It is not a trademarked name.
Jim




Reply With Quote
  #7  
Old   
news.verizon.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 09:55 PM



"news.free.fr" <grille11 (AT) yahoo (DOT) com> wrote

Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB
(tables, PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from
sql to oracle.
The datatypes of the source tables (from Oracle) are number,
varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping



Oracle uses SQL so I don't understand what you are migrating to. SQL stands
for Structured Query Language. It is not a trademarked name.
Jim




Reply With Quote
  #8  
Old   
news.verizon.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 09:55 PM



"news.free.fr" <grille11 (AT) yahoo (DOT) com> wrote

Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB
(tables, PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from
sql to oracle.
The datatypes of the source tables (from Oracle) are number,
varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping



Oracle uses SQL so I don't understand what you are migrating to. SQL stands
for Structured Query Language. It is not a trademarked name.
Jim




Reply With Quote
  #9  
Old   
news.verizon.net
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-02-2008 , 09:55 PM



"news.free.fr" <grille11 (AT) yahoo (DOT) com> wrote

Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB
(tables, PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from
sql to oracle.
The datatypes of the source tables (from Oracle) are number,
varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping



Oracle uses SQL so I don't understand what you are migrating to. SQL stands
for Structured Query Language. It is not a trademarked name.
Jim




Reply With Quote
  #10  
Old   
Robert Klemme
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-03-2008 , 08:03 AM


On Apr 2, 6:48 pm, "news.free.fr" <grill... (AT) yahoo (DOT) com> wrote:
Quote:
Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables,
PK, possibly some views triggers and SP).
I am trying to migrate tables from oracle 10.2 to a MS SQL 2005.
I thought oracle sql developper would do this but it migrates only from sql
to oracle.
The datatypes of the source tables (from Oracle) are number, varchar2,date)
My difficulty is to properly map the oracle datatype to SQL.
Does anyone have an idea?
thanks for helping
With MS SQL Server 2k you could use DTS, there is probably a similar
tool for MS SQL Server 2005.

Kind regards

robert


Reply With Quote
Reply
Page 1 of 3 1 2 3 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top