Thursday, March 29, 2012

backup stored procedures?

Hey all,
I have to copy all the stored procs that i have on my development server to the clients server when I deploy my .NET app. I do not have remote access to the clients server. Anyone knows how I could do this? Are there any settings to take care of?
TIAScript your procedures to a file and then execute it through your install.

How are you getting the tables created?|||The tables have already been created by someone else.

Could you explain more about scripting the procedures to a file and executing through install??

Thanks !!|||In Enterprise Manager, select your stored procedures, right-click, and the follow the menu steps to generate a script. What you will get will be SQL statements that create your procedures. Save them to a file and then execute them during your install.

No comments:

Post a Comment