How to compare table from SQLSERVER 2005 with oracle

Hi,

i am trying to compare the table which is existing in SQL server2005 with the same in oracle 10g. is there any short cut procedure for it..?

Sreenivas

What do you want to compare the schema of the data ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i want to compare the table structure including the datatypes of some xxx table in sql server with oracle table which is having the same name and structure..these two are located in different databases and different locations with different schema names..|||

I have a script for SQL Server which does the things on two different SQL Server databases. For Oracle you would have to do a comparison betwen the datatype which can differ although they are in common the same. Just write me a mail if you want to have this script.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jen,

Could u mail me the script for SQL server comparison..i dont have any script for oracle ...

I am trying to reach you at your mail id. but surprisely it bounce back to me..