Post reply

DB Schema Compare Scripts

  • April 16, 2015 at 11:46 am

    #296135

    Hello

    I am looking for some SQL Scripts/tool to compare the two sql database and generate the difference results into Excel file. I am not looking for Sync/change scripts.

    Example:

    Result Type Desc

    -----------------------

    Col1 Column Added

    Table1 Table Removed

    Thanks

    Shuaib

  • April 16, 2015 at 2:10 pm

    #1791476

    SQL Server Data Tools can do that, and it's free. It won't output an Excel file though.

    -- Gianluca Sartori

  • April 16, 2015 at 3:34 pm

    #1791502

    Redgate SQL Compare[/url] can do that and then export to XML for Excel. It can also export to HTML and a few other formats.

    DISCLAIMER: I work for Redgate.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 16, 2015 at 5:46 pm

    #1791527

    Can we do this in Redgate SQL Compare 8? We have the older version.

    Thanks

  • April 16, 2015 at 8:47 pm

    #1791542

    ShuaibV (4/16/2015)

    Can we do this in Redgate SQL Compare 8? We have the older version.

    Thanks

    I'm not sure. You do the compare then go to Tools, Generate Report and look at Format.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 20, 2015 at 7:31 am

    #1792019

    You might try this one:

    http://opendbiff.codeplex.com/releases/view/72756

  • April 21, 2015 at 10:55 am

    #1792482

    +1 for RedGate.

    They also have a data compare so that you can script config and static data

    Their tools also integrate very nicely into SSMS and SQL compare can handle scripting from source code repository (Subversion, Mercurial or TFS)

    You can download a fully working evaluation copy

    Plus they are the primary source of funding for this site

    Not an employee, just a happy customer

  • April 21, 2015 at 11:09 am

    #1792502

    aaron.reese (4/21/2015)

    +1 for RedGate.

    They also have a data compare so that you can script config and static data

    Their tools also integrate very nicely into SSMS and SQL compare can handle scripting from source code repository (Subversion, Mercurial or TFS)

    You can download a fully working evaluation copy

    Plus they are the primary source of funding for this site

    Not an employee, just a happy customer

    Thanks!

    And you can call them all from the command line and automate the processes.

    And I do work for them.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 27, 2015 at 12:50 pm

    #1793803

    Thank you! I am using Redgate 8 and happy with it so far. But wont be able to upgrade for now to use it against 2012 and later version.

    Thanks

  • April 27, 2015 at 12:51 pm

    #1793804

    Thank you. I will try.

    Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

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