Post reply

copy sprocs to new (beta) DB

  • February 14, 2005 at 4:46 pm

    #68052

    When we receive updates to our DB we update the beta DB first, test then update our live DB. The process at the moment, for stored procedures, is to go thru the live DB, identify our SPs and script them out then run the script in the beta DB.

    Is there a way of checking the SPs in the live DB to see if they exist in the Beta DB, if they don't, create them in the Beta DB????

  • February 14, 2005 at 8:16 pm

    #542172

    You could try interogating the SYSCOMMENTS System Table for the Stored Proc Name to see if it exists!

    Kindest Regards,

  • February 14, 2005 at 9:03 pm

    #542174

    Better than looking at Syscomments. Use the Information_Schema views. Best bet is probably INFORMATION_SCHEMA.ROUTINES.

    Although given that you're comparing object across different servers, It might be better to try one of the many Schema comparison tools that are available.

     

    --------------------
    Colt 45 - the original point and click interface

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

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