Table comparison | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Table comparison

I’ve been having the classic problem of not beeing structured enaugh in my work to document the changes I do in the test-database so when the time comes to deploy the changes I have to manually check a bunch of tables and indexes and all this for changes. I have read a bit about it and come to realize that there are tools to automate this, but I was sort of hoping it was possible to generate an alter-script from the sql-server like I do with the sp’s and just run through them in QA but I just haven’t been able to get them to work without alot of hassle…does anyone have any pointers? I also belive I read something a while ago about an sp someone wrote to compare databases but I seem to have lost where it was. If I could easily find the differences I could always manage to do the manual updates… —
Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
You can use REDGATE’s SQL COMPARE to accomplish the task and also LockWoodTech’s tools.
And this is the linkhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1071&SearchTerms=compare,databases posted by Gaurav a while ago.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
But from what I can see the comparison needs to be on the same server…? Or am I mistaken? I need to run the comparison on two completely different boxes, the test-server in our office and the production-server is at Rackspace. —
Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
Yes its on same server between 2 databases, may try to modify the script to connect to other server. I’m not sure whether linked server will have any use here. If not you can take full backup of production database or schema itself and restore on the test box, then run this script to accomplish the task. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Ok, thanx alot, I will give it a go <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />–<br />Frettmaestro<br />"Real programmers don’t document, if it was hard to write it should be hard to understand"
]]>