OraFAQ Forum: Server Administration » Help on SQL Server 2000 to Oracle 10g

Home » RDBMS Server » Server Administration » Help on SQL Server 2000 to Oracle 10g

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

Help on SQL Server 2000 to Oracle 10g [message #408917]

Thu, 18 June 2009 05:30

snivas
Messages: 1
Registered: June 2009
Location: Bangalore

Junior Member

We are doing migration from SQL Server 2000 to Oracle 10g

some body provide me what are the things I need to look into while doing migration.

Thanks In Advance

Report message to a moderator

Re: Help on SQL Server 2000 to Oracle 10g [message #408919 is a reply to message #408917]

Thu, 18 June 2009 05:37

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

You should count down all objects and all rows of tables from Sql Server side and then compare them with Oracle after migration

Report message to a moderator

Re: Help on SQL Server 2000 to Oracle 10g [message #408923 is a reply to message #408919]

Thu, 18 June 2009 05:47

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Also T-SQL from SQL Server

Report message to a moderator

Re: Help on SQL Server 2000 to Oracle 10g [message #408927 is a reply to message #408917]

Thu, 18 June 2009 06:11

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Transaction management, concurrency and locking.

Regards
Michel

Report message to a moderator

Re: Help on SQL Server 2000 to Oracle 10g [message #409118 is a reply to message #408927]

Fri, 19 June 2009 08:29

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Look into the Temporary Table creation in T-SQL, with an eye to removing it completely in the Oracle migration.

Report message to a moderator

Previous Topic:	DB Link problem.
Next Topic:	ora-00972 (identifier too long) vs. design

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:50:38 CST 2024