How to compare two tables from two servers.

Question

How to compare two tables from two servers.

igngua

SSCrazy

Points: 2510
More actions
November 26, 2009 at 6:26 am

#206775

Hello...the scenario is as it follows...
Two servers (A and B) .
A = development
B = Production
Tables on development are constantly changing it desing so its hard to keep track of all the changes. Is there any way to compare the two tables to know if there is any change?
little question: in the tab navigation menú (the one on the right by default), how can i make that MS shows the server i´m consulting ?? it only shows the schema y and table name...that´s a little confusing when i´m working.
Thanks in advance.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323482 More actions · Answer 1

by changing, do you mean schema changes, ie new columns, defaults,constraints, datatype changes, etc, or do you mean data changes, like new rows of data,others updated/deleted

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

igngua SSCrazy Points: 2510 More actions · Answer 2

Lowell (11/26/2009)
by changing, do you mean schema changes, ie new columns, defaults,constraints, datatype changes, etc, or do you mean data changes, like new rows of data,others updated/deleted

i mean schema changes, columns defaults etc.... i believe that´s called table design or not ??

tnk SSCrazy Points: 2613 More actions · Answer 3

There are manual ways to do it, sure, but if you're going to be working with staged dev/test/production databases, you need to know about Red Gate SQL Compare and SQL Data Compare. These two tools will pay for themselves in no time.

http://www.red-gate.com/products/index.htm

As the upper right corner of this website says, they sponsor this site, but I wouldn't recommend it if I didn't absolutely love their software. It saves my team immeasurable amounts of time. It's hard to quantify. It also gives you that peace of mind knowing that you didn't forget to deploy a sproc or a new view.

Dugi SSCoach Points: 17998 More actions · Answer 4

It will take long time if your table has lot of columns and many data types, here I'm talking for the structure of the table and all other objects related to that table.

So the better solution is the third part application for compering like RedGate Compere or you can find many other application for compering everything between 2 DBs or 2 Servers and DBs inside them!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

SQLRNNR SSC Guru Points: 281324 More actions · Answer 5

And I will give my vote to RedGate SQL Compare for schema and objects, and RedGate Data Compare for comparing the data in tables.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

igngua SSCrazy Points: 2510 More actions · Answer 6

igngua

SSCrazy

Points: 2510

December 3, 2009 at 5:31 am

#1087006

thanks guys! i´ll check it....