File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 22

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: 36520
    
  16
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: 22

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: 1106

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: 22

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: 3438
    
  47

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.
 
Similar Threads
in what condition the equls to compare whether the two are the same object?
Utility to compare two XML files
string array comparision in perl
How To Comapre To Excelsheet
Problem with Date Object