• I'd suggest writing a PowerShell script to run the export and import of the procedures. That should be fully automated and ought to work well.

    Another approach would be to put the procedures into source control (where they should be anyway). You can then use PowerShell or even a third party tool to deploy from there in an automated fashion.

    "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