This can be done, but you will need to write a series of very complex cursors to go through each record in the INFORMATION_SCHEMA.COLUMNS view and see if the matching column exists in the other database, if it doesn't add it using the ALTER TABLE command. You'll get much more reliable results if you use something like TOAD or Change Director from <a href="http://www.quest.com">Quest Software</a> to compare the databases and see what the differences are. These products can also generate change scripts which can be used to sync up the differences.

This can be done, but you will need to write a series of very complex cursors to go through each record in the INFORMATION_SCHEMA.COLUMNS view and see if the matching column exists in the other database, if it doesn't add it using the ALTER TABLE command. You'll get much more reliable results if you use something like TOAD or Change Director from <a href="http://www.quest.com">Quest Software</a> to compare the databases and see what the differences are. These products can also generate change scripts which can be used to sync up the differences.