ORACLE AND SQL SERVER (migration) [message #417082] |
Thu, 06 August 2009 00:13  |
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 #417098 is a reply to message #417082] |
Thu, 06 August 2009 01:14   |
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   |
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 #417158 is a reply to message #417082] |
Thu, 06 August 2009 05:44  |
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.
|
|
|