Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Compare an Oracle Database with a Sql Database ! Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 5:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 3:36 AM
Points: 16, Visits: 41
Hi,

first of all, i'm biginner in Bi Consulting with Microsoft tools.

I want to compare two databases : Oracle Database and Sql Database

both of databases have the same data but not the same naming of Table or Columns for sure !

I thought to create a linked Database in SSMS, but i'm not administrator and i can't modify the Production Database

May be i can use PowerPivot in Excel but I don't know how ?

so any idea please ?

Thank you
Best regards.
Salmita
Post #1453446
Posted Monday, May 20, 2013 6:53 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
salmita (5/16/2013)
I want to compare two databases : Oracle Database and Sql Database
both of databases have the same data but not the same naming of Table or Columns for sure !


I do love self answering questions. Do not bother, databases are different.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1454511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse