Post reply

Compare prod database from dev

  • October 27, 2015 at 5:19 am

    #306109

    Hi,

    Could you please give me some idea to compare prod database objects from dev. Prod runs using cyber account(window authentication) and dev runs using normal account.

    Thanks

    Sushil

  • October 27, 2015 at 5:27 am

    #1835730

    I would recommend SQL Compare from Red-Gate, I use it all the time, great tool.

    Others are available, SSDT has one, also one from ApexSQL.

    There is a freeware tool called DBComparer but last I used this was for 2008, the site doesn't say anything about 2012 or above so may or may not work.

  • October 27, 2015 at 5:31 am

    #1835735

    You could compare the definitions in the system tables and use the EXCEPT operator to filter out the objects that are the same.

    If you're looking for a ready-made product, I've heard good things about Red Gate SQL Compare, but haven't used it myself.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 27, 2015 at 6:11 am

    #1835745

    I also recommend SQL Compare, though if your databases are developed using VS DB projects, there is a Schema Compare tool built in.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • October 28, 2015 at 8:33 am

    #1836079

    thanks for your suggestions..

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

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