Home » Open Source » Programming Interfaces » Migrating Sql server backup to Oracle database
Migrating Sql server backup to Oracle database [message #591224] Thu, 25 July 2013 12:29 Go to next message
irfankundi786@yahoo.com
Messages: 205
Registered: February 2009
Location: pakistan
Senior Member

what is east way to migrate from sql server backup to oracle database?????explain detail steps>>>>>
Re: Migrating Sql server backup to Oracle database [message #591226 is a reply to message #591224] Thu, 25 July 2013 12:32 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The most important thing is not to migrate the data, it is very easy, but to migrate the application.
Do you think to migrate it? And I don't talk about changing the SQL syntax but the whole code to change the transaction processing.

Regards
Michel
Re: Migrating Sql server backup to Oracle database [message #591228 is a reply to message #591226] Thu, 25 July 2013 12:39 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 205
Registered: February 2009
Location: pakistan
Senior Member

first of all i want to migrate the structure and all other objects of database.....
it is easy but how please give step by step detail
Re: Migrating Sql server backup to Oracle database [message #591229 is a reply to message #591226] Thu, 25 July 2013 12:47 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 205
Registered: February 2009
Location: pakistan
Senior Member

please help me..waiting for your response?
Re: Migrating Sql server backup to Oracle database [message #591232 is a reply to message #591229] Thu, 25 July 2013 13:00 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just copy and paste the DDL you have and when there is an error just read the error message, refer to the documentation and change accordingly.

Regards
Michel
Re: Migrating Sql server backup to Oracle database [message #591234 is a reply to message #591229] Thu, 25 July 2013 14:06 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 205
Registered: February 2009
Location: pakistan
Senior Member

i am using oracle developer all the steps are performed when i reached the step of tool...migrating..>connection...>offline...offline capture file...>when i select ok....error is generated...error is generated click detail for more information....
Re: Migrating Sql server backup to Oracle database [message #591235 is a reply to message #591234] Thu, 25 July 2013 14:17 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So case is closed?

Regards
Michel
Re: Migrating Sql server backup to Oracle database [message #591239 is a reply to message #591235] Thu, 25 July 2013 15:44 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I guess not; he's waiting for instructions (i.e. click "details" for more information).
Re: Migrating Sql server backup to Oracle database [message #591246 is a reply to message #591239] Thu, 25 July 2013 16:47 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 205
Registered: February 2009
Location: pakistan
Senior Member

how i can solve the problem???
Re: Migrating Sql server backup to Oracle database [message #591249 is a reply to message #591246] Thu, 25 July 2013 17:00 Go to previous message
BlackSwan
Messages: 21948
Registered: January 2009
Senior Member
Just copy and paste the DDL you have and when there is an error just read the error message, refer to the documentation and change accordingly.
Previous Topic: NVARCHAR2 to RAW Different behaviour SQL and PLSQL
Next Topic: HttpServlet - help me to make 'SQL injection' - buggy code inside
Goto Forum:
  


Current Time: Sat Apr 19 13:33:55 CDT 2014

Total time taken to generate the page: 0.10094 seconds