November 4, 2009 at 5:01 am
Hi friends,
Presently in order to synchronize two databases w.r.t tables, columns and constraints we use a tool. I was wondering is it possible to have a query to compare the schema of two different dbs keeping one as master and the other as slave and all those master tables that are not in slave should be pointed out and if possible the query should make a DDL for such a table with Create or Alter depending upon their existence and differences.
Thanks.
Regards,
Waqas.
November 5, 2009 at 7:52 am
Probably not answer you are expecting but you can try red gate sql data compare, http://www.red-gate.com/products/SQL_Data_Compare/index.htm
It should be able to generate the scripts for you.
November 5, 2009 at 8:49 am
What tool do you presently use for DB schema comparison?
--
:hehe:
November 5, 2009 at 10:53 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply