how to transfering stored procedure and functions from one database to another database?

Question

I am using sql server 2005 and i want to transfer my all stored procedures and functions to another newly created database. How i can do this by writing one stored procedure. Can any one tell me help me regarding this?

Not sure if this is could help: http://stackoverflow.com/questions/945325/syncing-stored-procedures-between-two-databases?rq=1 — Mad Dog Tannen, Oct 28 '13 at 10:40

score 0 · Answer 1 · answered Oct 28 '13 at 10:50

0

You can use generate script feature and run it on another database. Right click on your database --> tasks--> generate script choose your objects and get the scrip then run it on the other database.

answered Oct 28 '13 at 10:50

Amir Keshavarz

3,050
1
19
26

I want through Stored procedures only. – Raghuveera Oct 28 '13 at 11:33
Generate script add it into stored procedure body. – Amir Keshavarz Oct 28 '13 at 11:36
i have 200 stored procedures in one database. i want to move this by executing a single stored procedure.Wether it is possible? – Raghuveera Oct 28 '13 at 11:43
Note that there is no mechanism that you can move procedures . you should recreate them. with generate script feature you can generate script for all of your procedures just in one time. and execute it so all you have other side. – Amir Keshavarz Oct 28 '13 at 11:46
1

I got the solution from http://stackoverflow.com/questions/19631009/no-answer-for-copy-stored-procedure-one-database-to-another – Raghuveera Oct 28 '13 at 12:03
But also generate script is more standard. – Amir Keshavarz Oct 28 '13 at 12:05
if i do like this what problem i may get...? – Raghuveera Oct 29 '13 at 12:04
There is no problem but generate script is a featute that ssms considers for this requests. So ir is more accurate. – Amir Keshavarz Oct 29 '13 at 13:16

how to transfering stored procedure and functions from one database to another database?

1 Answers1