SQL/T-SQL - February 2015

Migrate stored procedures across databases

Copy stored procedure from one database to another with T-SQL
When working on an app you create all your stored procedures, functions, tables, view and other objects in a development database (or t least it should be like that). A small but annoying problem occurs when you have to migrate your stored procedures to test or production database. Imagine during development you had let's say 20 stored procedures ... read more