Home » RDBMS Server » Server Administration » Help on SQL Server 2000 to Oracle 10g
Help on SQL Server 2000 to Oracle 10g [message #408917] Thu, 18 June 2009 05:30 Go to next message
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
Re: Help on SQL Server 2000 to Oracle 10g [message #408919 is a reply to message #408917] Thu, 18 June 2009 05:37 Go to previous messageGo to next message
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
Re: Help on SQL Server 2000 to Oracle 10g [message #408923 is a reply to message #408919] Thu, 18 June 2009 05:47 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Also T-SQL from SQL Server
Re: Help on SQL Server 2000 to Oracle 10g [message #408927 is a reply to message #408917] Thu, 18 June 2009 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Transaction management, concurrency and locking.

Regards
Michel
Re: Help on SQL Server 2000 to Oracle 10g [message #409118 is a reply to message #408927] Fri, 19 June 2009 08:29 Go to previous message
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.
Previous Topic: DB Link problem.
Next Topic: ora-00972 (identifier too long) vs. design
Goto Forum:
  


Current Time: Sat Dec 03 01:33:38 CST 2016

Total time taken to generate the page: 0.24233 seconds