This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Compare two databases. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Compare two databases." Watch "Compare two databases." New topic
Author

Compare two databases.

N. Ganapathy
Greenhorn

Joined: Apr 16, 2012
Posts: 24

Please help me out. i want to compare two database of different servers. kindly provide me any solutions.


Regards,
Ganapathy.N
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38441
    
  23
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

Joined: Apr 16, 2012
Posts: 24

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

Joined: Oct 21, 2008
Posts: 1107

which database is it (oracle, mysql etc) As i bet some come with really handy tools to tell you this information.
N. Ganapathy
Greenhorn

Joined: Apr 16, 2012
Posts: 24

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

Joined: Aug 22, 2010
Posts: 3610
    
  60

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Compare two databases.