I have a MS SQL Table containing user data, e.g. Username and ID. This list should be compared with another list which is available as XML Document. Fortunately MS SQL 2005 is able to process XML so I searched around and found a post from Divya Agrawal on MSSQLTips.com. In Divyas tip 2 XML files are compared, so I modified it to compare XML and SQL row.
While migrating a SQL-Database from stage to live I searched for an easy way to identify all changes I made. Of course I wrote them all down in my update log, but it should not be too complicated for a tool to automatically compare 2 databases. And yes, there is at least one tool, and best of all: It’s free!! (Ah no, best of all is that it’s working fine, but it’s also great that it’s free….)
As I’m no SQL DBA I wondered how to get details about my current databases, especially the size, because suddenly my database size increased a lot and I had no initial idea why. Microsoft SQL Server Management Studio (for MS SQL 2005) does not seem to have an easy solution for this. So searching around I found a freeware tool from SQLDBTools.com called SQLDBSize.
Additionally a colleague informed me about a script from Mohit Nayyar he found at SQLServerCentral.com :