Comparing tables

  • Dear Friends,

    I am having a database and some tables in that are specific to my application (as it is comman to all this db hold all the tables and related object).

    In order to give the database backup to my client I have exported the required objects and generated a database, took a backup and gave it to my client.

    Now there are some issues and some settings like default setting, identity were missing in the backup.

    I want an easiest way to compare the tables and if not matches then that alone has to be scripted instead of doing the above once aain.

    Is there a way to compare the table and related objects and then it not matching that alone to be exported.

    Thank you a lot in advance

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

  • There are plenty of tools out there that can compare differences in DB Schemas. They even have the ability to create scripts to quickly/easily sync them. I personally use Red Gate. However, I'm sure you can find some open source utilities.

    Eli

  • Hi,

    There is another MS utility named as Tablediff which will compare data between 2 tables. Please check below link.

    http://msdn.microsoft.com/en-us/library/ms162843.aspx

    Regards

    GURSETHI

  • Dear Friends,

    Thank you a lot for your support.

    I will try to use it.

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

  • Dear Friends,

    Thank you a lot for your support.

    I will try to use it.

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

  • Dear Friends,

    Thank you a lot for your support.

    I will try to use it.

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

Viewing 6 posts - 1 through 5 (of 5 total)

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