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)
is there any way can i do it at time ?
Ravi PatelPosted May 17, 2014, 1:48 AM
Abhay ShankerPosted May 16, 2014, 2:00 PM
follow below steps to
· In SQL Server Management Studio, go to the Object Explorer
· Find your database
· Right-click on it > Tasks > Generate Scripts
· Pick stored procedures and functions as your objects to script out
· Script them out to a file (or a bunch of files)
· Run those files on your other SQL Server
Hussain AhmedPosted May 16, 2014, 10:57 AM
http://www.c-sharpcorner.com/UploadFile/834980/generate-sql-script-with-data-in-sql-server/
Anupam SinghPosted May 16, 2014, 10:01 AM
you didnt mention version or database server(SQL ,MYSQL,ORACLE).
anyways if you are using SQL Server :
then follow the steps mentioned below :
open SSMS(Sql server management studio):
1.right click on databse >
2.tasks >
3.Generate Scripts>
4.Select Specific Database Objects>
5.Choose Store Procedures>
6.Click Next>
its done :)
Excecute this to your new server.