13. A computer program product having program codes stored on a computer-readable device read and executed by a computer, results in the computer performing a method for deploying a structured query language (SQL) procedure, the method comprising: creating the SQL procedure comprising a procedure logic component that comprises one or more loop statements, conditional statement and other control statements and a database request component that comprises one or more SQL statements from a source system to a target system, wherein the procedural logic component and the database request component are deployed separately from the source system to the target system, generating source code, a symbol table, and optimization results for the structured query language procedure, in order to regenerate run-time instructions for the SQL statements of the database request component, wherein the SQL statements of the database request component function with a deployed version of an internal representation of the procedural logic component; maintaining an association between the procedural logic component and the database request component during deployment; copying the deployed version of the internal representation of the procedural logic component to the target system without regeneration; regenerating the database request component to recreate the structured query language procedure on the target system, and to maintain a consistent interface between the procedural logic component and the database request component.
15. The computer program product of claim 13 , wherein the optimization results contain results generated by a compiler with respect to the procedural logic component and an interface of the procedural logic component with the database request component, preserving optimization results upon deployment of the structured query language procedure to the target system.