I have been working on a local copy of my database and have created a number of new stored procedures. I would like to upload the new stored procedures to my on-line database from my local database and am not sure how to do it. Nothing needs to be changed but to have the stored procedures added.

Can someone please tell me how to do this? Please be sure to explain clearly and completely as I am not a power user.

I have the Enterprise version of SQLyog 6.15.

Thanks in advance!

Hi,
Follow the steps below so that you copy any routines to copy to different host or db,

1. Select source db (local db).
2. Then click on DB menu - Copy DB to different host or db.
3. Select target db or host (online db).
4. Then select which routine to be copied. So, you can check or uncheck which is required or not respectively.
5. Select Copy.

You can also read the FAQ link below regarding Copy DB,
http://www.webyog.com/faq/content/26/32/en...fferent%20hosts

Regards,
Navya

Hi,
There is an another option to copy new stored procedures in target DB by using Structure Synchronization Tool. Structure sync the source and target databases. In this when you sync two databases it shows the difference. So that you can copy the routines which is newly created from source to target. Please read the link below,

http://www.webyog.com/faq/content/10/85/en...-and-views.html

And about previous reply, Copy DB option also can be considered only when as a whole routines like store procedures, functions etc.,. to be copied to target DB.

Regards,
Navya

In 6.2 it will be possible to select individual SP's and other objects (not only tables) for copy and export operations.

Hi :-)

Assuming you are connected to both databases from SQLyog you can do it manually. Create a new SP in the other dababase and copy over the code from the SP editor. Not elegant but it works. Make sure to select the correct DB when you do this or else you may see the SP created in the wrong DB

- Per