Results 1 to 8 of 8

Thread: Database Diff?

  1. #1
    Join Date
    Dec 2002
    Posts
    45

    Unanswered: Database Diff?

    I have 2 databases:
    1 from production and 1 from development.
    None of the developers kept a changelog so i need to know what has changed (or what is different between the 2).

    Any Ideas on how to do this?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    A quick method is to compare selects from sysobjects, syscolumns, and sysindexes.

    blindman

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Then give the output of those queries to the developers so they can sift through them. Only proper, I would imagine.

  4. #4
    Join Date
    Dec 2003
    Location
    New jersey, USA
    Posts
    9
    A quick, first run is to compare the date modified of the objects. Of course this does not compare contents. I've done it this way and it wasn't as bad as it sounds. Good luck.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...and a quick way to identify modified procedure code is to compare checksum(syscolumns.text) between the two databases.

    blindman

  6. #6
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    if this is recurring task and if your department has a few dollars to spare (as we all have ...), you can use software for this, e.g. http://www.red-gate.com/sql/summary.htm
    Johan

  7. #7
    Join Date
    Sep 2003
    Posts
    364
    SQLDiff by ApexSQL is a good tool too. There are some free database compare scripts at http://www.sqlservercentral.com/. Just look in their script section on the site.

  8. #8
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Another way - create db scripts (use DMO) and compare by FC.exe (included in W2000).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •