25. A processor-implemented system for deploying a structured query language (SQL) procedure the system comprising: a source system, implemented by a processor, for 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, and, for 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; a catalogue, stored on the source system, for maintaining an association between the procedural logic component and the database request component during deployment; a copying module, executed by the source system, for copying the deployed version of the internal representation of the procedural logic component to the target system without regeneration; a target system, implemented by a processor, for executing a target bind package module for 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.
26. The system of claim 25 , wherein the symbol table provides a linkage between the database request component regenerated on the target system and the deployed version of the internal representation of the procedural logic component.