What I personally do is, create a script and run it on both the databases.
Vyas, MVP (SQL Server)
to explain it in a simple way. I have 2 identical databases. i added a
field to a table in the first database. i want the second database be
affected without runing the field addition script on the second database.
See the information_schema views. Not all info is available through this
and you will have to use the system tables for some things - see tables
beginning with sys...
You could script the database via dmo from VB - see
There are also products that will compare databases and produce scripts
to update them.
Posted via http://dbforums.com
2. ADO for C++