Home » Topic » What is the best way to compare database structure?

What is the best way to compare database structure?

Michael Scofield ~ Modified: September 27th, 2016 ~ ~ 1 Minute Reading

Home › Forums › What is the best way to compare database structure?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 27, 2016 at 1:49 pm #3520 Score: 0
    Michael Scofield
    Moderator
    20 pts

    I have three databases in my SQL Server for different purposes. Out of which two of the databases are very large in size and contained the complete DB structure. Now before merging the two Databases, I want to compare the complete DB Structure to verify the similarity between two. So when I try to do it manually it is showing me an error repeatedly. Since the size is huge, so repeating the same thing becoming difficult for me.

    So, I want to know that is there any best procedure or application that may easily compare the two DB structure?

    October 3, 2016 at 1:39 pm #3582 Score: 0
    Eddie Thwan
    Moderator
    44 pts

    Hi Michael,

    While we implement a database we need to make sure the DB schema which is running in the live environments and development are not same. SO to analyse this, you have to compare the two of these database. Doing the same with manual solution may be time takes as it may take many hours to complete the comparison. So the easiest way for doing the same comparison is to choose a third party tool. But if you’ve very less size of database, then I recommend to use a manual solution first.

    October 4, 2016 at 12:04 pm #3598 Score: 0
    Michael Scofield
    Moderator
    20 pts

    Hi Eddie,

    thanks for the reply, I’ve already tried the manual solution which fails to compare my database schema. I think it will be far better to go through any freeware if available?

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.