Post reply

Comparing objects from two databases

  • October 14, 2005 at 1:17 pm

    #88188

    Hello,

    I need to compare the structure of all the tables (I mean: field definition, keys, constraints, indexes) and the code of all stored procedures of a database against the "corresponding" object from another database, in order to know if the database is up to date.

    Any advice, tool, or sql code about this issue will be welcome.

    Thanks in advance,

    Felix

     

  • October 14, 2005 at 4:47 pm

    #597479

    I use Red gate's SQL Compare software for this.  It's got all of what you need.

    http://www.red-gate.com/products/SQL_Compare/index.htm

     

     



    A.J.
    DBA with an attitude

  • October 15, 2005 at 1:07 am

    #597494

    Apex also has a nice product.

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

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