Page 1 of 1

Can We Migrate Acces or SqlServer DB To Oracle

Posted: Fri Apr 20, 2007 9:24 am
by lucky
I want to migrate sqlserver database and access database to Oracle Database.Please tell me solution of that.


Thanks in advance

Posted: Sat Apr 21, 2007 1:10 am
by ahmadbilal
Lucky
you can try
<b>Oracle SQL Developer Migration Workbench</b>

http://www.oracle.com/technology/tech/m ... _omwb.html



[quote]I want to migrate sqlserver database and access database to Oracle Database.Please tell me solution of that.


Thanks in advance

<i><div align="right">Originally posted by lucky

Posted: Thu Apr 26, 2007 4:37 am
by lucky
thanks for that

but still i dont have any solution
oracle developer just has a connection with access and oracle but not connecting with sqlserver and mysql
please tell me how to do that.
if there are some settings tell me about that

Posted: Thu Apr 26, 2007 9:44 am
by ahmadbilal
Dear there are two things

1- access (coonect forms with sqlserver / access database)
2- migrate sqlserver to access database)

If you are talking about connection (option 1) you can do that by hsodbc) there is a utility in sqlserver to connecting with forms
if you are talking about option 2 then look at my last reply "Oracle SQL Developer Migration Workbench"


its your call what you want


[quote]thanks for that

but still i dont have any solution
oracle developer just has a connection with access and oracle but not connecting with sqlserver and mysql
please tell me how to do that.
if there are some settings tell me about that

<i><div align="right">Originally posted by lucky

Posted: Fri Apr 27, 2007 8:15 am
by musman
i am talking about option 2.but i want to migrate sqlserver to oracle or access.i am not understanding how this have to do using oracle developer migration workbench.please tell me how to use it.