Wednesday, March 7, 2012

How to compare structure of two db objects?

Hi,

I would like to compare an object inside a local and remote db and I would like see if any changes has been made to the object structure (table) since the last update.

ThanksRed Gate (www.red-gate.com) has a tool SQL COmpare that does exactly that.

To do it on the cheap, you might want to script the object in each copy of the database and then do a text compare of the two.|||I guess we were on the same page, thanks.

No comments:

Post a Comment