Hi,
I use a lot of Stored Procedures with my Apps. I also use several databases at the same time. The databases represent fiscal years of data, so the only difference between them is updates made to the information from year to year. When a new year comes around, I simply copy the tables from the previous year into the new year database. Is there any way to simply copy all the stored procedures from one database to another without having to individually copy and paste the SP code?
Thanks for any help.
I use a lot of Stored Procedures with my Apps. I also use several databases at the same time. The databases represent fiscal years of data, so the only difference between them is updates made to the information from year to year. When a new year comes around, I simply copy the tables from the previous year into the new year database. Is there any way to simply copy all the stored procedures from one database to another without having to individually copy and paste the SP code?
Thanks for any help.