Hi again… yesterday I was evaluating a tool called DBArtisan 8.5.0 by Embarcadero Technologies. Now I have not used this product in the past so I am not able to do a comparison. This tool has a lot of slick, GUI interfaces into SQL Server. So for those of you like myself who like the GUI interface this is a great tool! As I am learning about this tool I have come across one cool feature it is the ability to generate a HTML file from Transact SQL result set. This is helpful when putting this information on an company intranet. I will update this blog with more helpful tidbits as I come across them. You can download the free trial for this tool from Embarcadero here.

The next tool I have in my arsenal is Red Gate’s SQL Compare. Now this tool is a must have for any DBA! This tool has saved me countless of hours comparing database schemas in different environments (development to staging, staging to production). The interface is very straight forward and easy to use. It will also generate and execute the Transact SQL statements to update the schemas in the source or destination databases. Red Gate has this tool available for download here. As I continue to use this tool more I will add more helpful hints. If you have any helpful tidbits please comment and share!