• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Compare two databases.

 
N. Ganapathy
Greenhorn
Posts: 25
Java Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please help me out. i want to compare two database of different servers. kindly provide me any solutions.


Regards,
Ganapathy.N
 
Campbell Ritchie
Sheriff
Pie
Posts: 49827
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please explain what you mean by compare? Have you got two versions of the same database and don’t know which contains the correct data (‍)?
 
N. Ganapathy
Greenhorn
Posts: 25
Java Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually i have two Databases which are similar. once is deployed in UAT and Another one in Production. Now i want to compare these two , to know what changes have been done recently.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
which database is it (oracle, mysql etc) As i bet some come with really handy tools to tell you this information.
 
N. Ganapathy
Greenhorn
Posts: 25
Java Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons

It is a SQL server 2005, i want query to compare the two databases. I am having query to compare databases of same server.. now i want to know how can achieve this between different servers??
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Googling up sql server compare databases gives a lot of interesting results. (Ya know, SearchFirst..... )

One of the more interesting is TableDiff.exe, a utility that comes right with SQL Server 2005. I cannot assist more with that, though, I'm not SQL Server guy.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic