I have seen some companies using schemas and the search path to deploy stored procedures. In every deploy a new schema is created for the deployed version and a

I have seen some companies using schemas and the search path to deploy stored procedures. In every deploy a new schema is created for the deployed version and all stored procedures are added to it from the repository. The new version of the application will use the new schema while the old version still uses the old schema. When the old schema is no longer needed it can be dropped with all procedures. I have seen other ways to deploy stored procedures but these often require being very careful about function API:s and delta scripts.