Does anyone have an opinion on specific “data comparison tools� We are looking for something to use in our test or dev environments that will be able to compare snaps shots of the data in a database before verse after a test event. We have been able to record and compare data in specific tables but are learning that other tables were also being changed that we didn#%92t track. We want to be able to see all changes to a database.
Red-Gate have a product that will do this: http://www.red-gate.com/products/SQL_Data_Compare/index.htm I have also used SQL Delta to do this: http://www.sqldelta.com/
Yes, Red Gate bundle. Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />ApexSQL Diff?<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />I'm downloading now. I have received the licenses.[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All in Love is Fair <br />Stevie Wonder<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS†with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
Have fun. I like their tools. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
