Home » SQL & PL/SQL » SQL & PL/SQL » ORACLE AND SQL SERVER (migration)
ORACLE AND SQL SERVER (migration) [message #417082] Thu, 06 August 2009 00:13 Go to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
hi all,
i just migrated oracle database to sql server database.
now i just to confirm all object are migrated properly or not( from oracle to sql server )
i want check all triggers on tables ?
is there any easiest way to check?
if u know then please tell me
Re: ORACLE AND SQL SERVER (migration) [message #417086 is a reply to message #417082] Thu, 06 August 2009 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
easiest than what?

If you don't trust the way you do it, you should choose another one.

Regards
Michel
Re: ORACLE AND SQL SERVER (migration) [message #417087 is a reply to message #417086] Thu, 06 August 2009 00:38 Go to previous messageGo to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
IF U KNOW ANY METHOD THEN please TELL
Re: ORACLE AND SQL SERVER (migration) [message #417096 is a reply to message #417087] Thu, 06 August 2009 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't SHOUT.

Regards
Michel
Re: ORACLE AND SQL SERVER (migration) [message #417098 is a reply to message #417082] Thu, 06 August 2009 01:14 Go to previous messageGo to next message
markh420
Messages: 2
Registered: August 2009
Junior Member
Data migration is an integral part of organizing data and we are using Solix Application Sunsetting and Migration solution which allows companies to map metadata between applications and create conversion rules for faster and seamless data migration. For more information visit solix.com.
Re: ORACLE AND SQL SERVER (migration) [message #417115 is a reply to message #417086] Thu, 06 August 2009 03:33 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Michel Cadot wrote on Thu, 06 August 2009 06:36
easiest than what?


Michel, Easiest would automatically imply easier than all other possible methods. Possibly if the OP had used the word easier then your question would have been valid.

@vivek_rol
Quote:
i want check all triggers on tables ?


What exactly do you want to check? If you mave migrated to SQL Server then surely a SQL ssServer forum is a more appropriate place for you to be asking this question...
Re: ORACLE AND SQL SERVER (migration) [message #417120 is a reply to message #417115] Thu, 06 August 2009 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Easiest would automatically imply easier than all other possible methods.

You're right, I read (and copy) "any easiest" as "any easier" maybe I should read it as "the easiest".

Regards
Michel
Re: ORACLE AND SQL SERVER (migration) [message #417158 is a reply to message #417082] Thu, 06 August 2009 05:44 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can get the details of the triggers that were in Oracle from USER_ / ALL_ / DBA_TRIGGERS.

As you've gone TO Sql Server, the details of exactly what survived the migration will be in SQL Server and are very unlikely to be visible from Oracle.
Previous Topic: Accessing remote path using SQL directory
Next Topic: Query a data inside a cursor (merged 4)
Goto Forum:
  


Current Time: Thu Feb 06 14:22:19 CST 2025