Post reply

Consistancy between SPROCs on file and SPROCs in database

  • October 5, 2006 at 5:56 am

    #174612

    Is there a way of quickly checking for consistancy between SPROCs held on file and SPROCs held in a database.  Do I have to buy software for this?

  • October 5, 2006 at 11:41 am

    #664396

    There's no native SQL Server tool for this.  We use ApexSQL Diff, and there are others that aren't very expensive.

    Greg

    Greg

  • October 6, 2006 at 2:48 am

    #664532

    I suspect that many DBAs have their own home-brewed solution to doing this, so that any changes from the released system can be instantly alerted to the DBA. I have one, but it would be too long and messy to post on this Forum. However, SQL Compare now does it so well and so accurately that I've ceased bothering and use it instead.

  • October 6, 2006 at 6:26 am

    #664566

    A quick and dirty method is to script the database object(s) and do a simple dos text compare.

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

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