October 29, 2009 at 10:25 pm
I'd like to compare between
TABLE A in Testing SERVER
and TABLE A in Production SERVER by each column.
In order to update value of each column If they're NOT the same.
I think I may write SQL for every column manually.
But I wonder if there is better solution to loop each column ?
Please advise me.
October 30, 2009 at 4:02 am
neo_pom (10/29/2009)
I'd like to compare betweenTABLE A in Testing SERVER
and TABLE A in Production SERVER by each column.
In order to update value of each column If they're NOT the same.
I think I may write SQL for every column manually.
But I wonder if there is better solution to loop each column ?
Please advise me.
Can you give a bit more details, are you looking to compare every row and if they are different which server would you update.
I take it that you dont want to overwrite the contents of table a on testing from the table a on production..
Although using tablediff I thin k would help you perhaps, that can be used to detect differenced between tables and generate the sql to match them. you could also write queries, use third party tools or create a SSIS package to do it.
this is a link for tablediff
http://www.replicationanswers.com/TableDiff2005.asp
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 30, 2009 at 4:20 am
Select * from TestServer.TableA
Except
Select * from ProductionServer.TableA
And
Select * from ProductionServer.TableA
Except
Select * from TestServer.TableA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply