How to Copy store procedure in SQL

Asked By shirleytjensen 30 points N/A Posted on - 06/14/2012

I m using SQL 2005. I want to copy the store procedure from one database to another. What is the procedure for this? 

• Status: Open
• Question Views: 789
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Crizda Bilano 0 points N/A #140966

How to Copy store procedure in SQL

 

If you are copying one database, then all you have to do is make a backup of it and then try to regain your back up from the second database. This is applicable if your purpose is to get one table DTS is the procedure that you have to do. Check it if it will work on your problem. If not then try this one if you will want to copy many tables the you better use BCP command line utility.  Try this command bcp db_name.schema_name.table_name out table_name.dat -c -t, -S source_server -T bcp db_name.schema_name.table_name in table_name.dat -c -t, -S destination_server –T. you better change the  -T to U as your username P as your password.  Check this out and it will help you to transfer data from one database to another thanks. 

About Crizda Bilano

Questions
0

Answers
102

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 06/14/2012
• Question Category: MS SQL Server