Stored Procedure Replication or copying (SQL Server)

Question

Is it posible to replicate or copy the stored procedure easy from one SQL Server to an other?

Answer 1

yes, you can Data Transformation services to export/import the stored procedure. or you can copy the syntax and execute it again on the other server

Answer 2

yes you can do this : http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

Hope this will help you :)

Answer 3

There are many ways of doing this as mentioned in this excellent article -

• Native replication features;
• Log shipping;
• Manual deployments, and;
• Automated deployments and synchronization.

You'll need to create an account on the site, alternatively you can use username/passwords provided by bugmenot.

Answer 4

is this a one-time thing or do you need to automate replication?