Query to synchronize two Databases

  • 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.

  • 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.


    Everything you can imagine is real.

  • What tool do you presently use for DB schema comparison?

    --
    :hehe:

  • we use ' SQL execMS '

    http://www.laplas-soft.com/

    Regards,

    Waqas

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply