Patent ID: 7739296

Claim:
A computer-implemented method comprising: identifying a remote stored procedure stored in a remote database management system; and automatically generating, by a processor, a local stored procedure stored in a local database management system, wherein the local stored procedure comprises connection code, invocation code, and data handling code, the automatic generating comprising: gathering remote metadata corresponding to the remote database management system and the remote stored procedure, the remote metadata comprising a remote database type; gathering local metadata corresponding to the local database management system, the local metadata comprising a local database type; in response to gathering the remote metadata, generating the connection code, wherein the connection code comprises a connection string corresponding to the remote database management system; in further response to gathering the remote metadata, creating the invocation code, wherein the invocation code comprises a call statement to the remote stored procedure based on the gathered remote metadata, the call statement mapping one or more input values from the local stored procedure to one or more input parameters corresponding to the remote stored procedure; and in further response to gathering the remote metadata, creating the data handling code, wherein creating the data handling code comprises setting one or more local stored procedure values, the setting including mapping one or more remote stored procedure results, the remote stored procedure results output from the remote stored procedure, to the one or more local stored procedure values.