distal-attribute
distal-attribute
distal-attribute
distal-attribute

copy procedure

User, date Message
Written by BubikolRamios
3 years ago
Category: General
327 posts since Thu, 14 Jan 10
Have a proc in one db and want to make same in another.
In first I can copy create code, and now ?
Can't find a way to paste that somewhere and execute in another db.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
Just use the "Export database" dialog: Set output to "Database" and select target database below.
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Thanks. Was playing with that but was not going anywhere until you extra told me (-:
Written by combuilder
2 years ago
30 posts since Thu, 08 Nov 12
This option works perfect!

But i cannot understand Why copying the code doesn't work!
Written by combuilder
2 years ago
30 posts since Thu, 08 Nov 12
anse:
After a few test, could you add this in the procedure code:
DELIMITER //
CREATE DEFINER .......
.....
END //
DELIMITER ;


With this extra code at the beginning and at the end, everything works fine!
Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
The DELIMITER is not part of the code physically required for creating the procedure, so it should not be contained in the "CREATE CODE" tab. For this purpose, HeidiSQL has a button (the one on the main toolbar with the red semikolon on it). If that was part of the CREATE CODE, that would also *implicitely* kill any delimiter you have set before via that button. That's not a good idea.
Written by combuilder
2 years ago
30 posts since Thu, 08 Nov 12
I tried what you told me in the previous meessage. Now, i understand!

I think you're right related to the CREATE CODE, but, i wonder Why don't you add this "extra" feature as an option, becasue i think it doesn't cost su much adding this as an option!


Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
The "make it optional please" argument is such overstressed already, it's used for just every feature request which does not make sense in many users eyes.

But apart from that, as said above: If the delimiter was part of the CREATE CODE, that would also *implicitely* kill any delimiter you have set before via that button.
 

Please login to leave a reply, or register at first.