VBA to compare two SQL Server Database table structure
Posted on 2009-05-07
I'm looking for some VBA code that would compare two databases on SQL Server 2005. I want to find all the fields that I need to add to the production database to make it equal my development database. In other words, I want it to find all the new tables, fields, and changes of datatypes, etc. that I need to put into the production database before releasing it. This changes are in my development db.