stored procedure

May 16 2014 9:43 AM

I have database ( Employee database having 1000 table and 500 procedure) in system1

and same database(Employee database) in another system2 having same number of table ie. 1000 table but number of procedures are different. i want to copy all procedure from system1 to sytem2 (in system2 we need to create some new procedures and some existing procedure need to update)