This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread 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 Android Security Essentials Live Lessons this week in the Android 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: 38041
    
  22
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: 3606
    
  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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Compare two databases.
 
Similar Threads
string array comparision in perl
Utility to compare two XML files
Problem with Date Object
in what condition the equls to compare whether the two are the same object?
How To Comapre To Excelsheet