OraFAQ Forum: Programming Interfaces » Migrating Sql server backup to Oracle database

Home » Open Source » Programming Interfaces » Migrating Sql server backup to Oracle database

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Migrating Sql server backup to Oracle database [message #591224]

Thu, 25 July 2013 12:29

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

what is east way to migrate from sql server backup to oracle database?????explain detail steps>>>>>

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591226 is a reply to message #591224]

Thu, 25 July 2013 12:32

Michel Cadot
Messages: 65849
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

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591228 is a reply to message #591226]

Thu, 25 July 2013 12:39

irfankundi786@yahoo.com
Messages: 269
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

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591229 is a reply to message #591226]

Thu, 25 July 2013 12:47

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

please help me..waiting for your response?

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591232 is a reply to message #591229]

Thu, 25 July 2013 13:00

Michel Cadot
Messages: 65849
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

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591234 is a reply to message #591229]

Thu, 25 July 2013 14:06

irfankundi786@yahoo.com
Messages: 269
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....

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591235 is a reply to message #591234]

Thu, 25 July 2013 14:17

Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So case is closed?

Regards
Michel

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591239 is a reply to message #591235]

Thu, 25 July 2013 15:44

Littlefoot
Messages: 21439
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).

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591246 is a reply to message #591239]

Thu, 25 July 2013 16:47

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

how i can solve the problem???

Report message to a moderator

Re: Migrating Sql server backup to Oracle database [message #591249 is a reply to message #591246]

Thu, 25 July 2013 17:00

BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Previous Topic:	NVARCHAR2 to RAW Different behaviour SQL and PLSQL
Next Topic:	open source banking software

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 21 23:20:55 CDT 2018