tongpo - 1:57 pm on Dec 21, 2012 (gmt 0)
Thanks for the reply. None of the tables hold any identical data between one and another. I don't want to transfer any data. They both hold similar data. Its just that I've added a couple of columns to one table in database1. I know need to replicate the structure of this table to the rest of the tables in this database and all of the tables in the other database, without altering existing data in any of them. Simply just add the new columns of one table (without data) to the rest of the tables and all tables in the other database. As easy n quickly as poss.