How to Copy store procedure in SQL

Asked By 30 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #140966

How to Copy store procedure in SQL

qa-featured

 

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. 

Login/Register to Answer

Related Questions