Transfer of table instances between databases

1. A method for transferring table instances X 1 , X 2 , . . . , X N of a table T from a source database S to N destination databases D 1 , D 2 , . . . , D N , respectively, said method being implemented by executing a computer code by a processor of a computer system, said N being at least 1, said method comprising for I=1, 2, . . . , N:

determining whether the table T has been defined for destination database D I , and if said determining determines that the table T has not been defined for the destination database D I then defining the table T for the destination database D I ; and

transferring the instance X I of the N table instances from the source database S into the defined table T of the destination database D I ,

wherein the method further comprises prior to said determining whether the table T has been defined for destination database D I and prior to said transferring the instance X I ;

specifying an instance configuration pertaining to the table instance X I , wherein the instance configuration consists of an instance variable of the table T in combination with a value of the instance variable, and wherein the instance variable defines a set of rows of the table T pertaining to the table instance X I ;

generating a first database query statement from said instance configuration pertaining to the table instance X I , wherein the first database query statement is configured to return the table instance X I from the table T in the source database S in response to being performed; and

performing a first source database query on the source database S using the generated first database query statement, resulting in returning the table instance X I from the table T in the source database,

wherein said determining whether the table T has been defined for destination database D I comprises:

generating a destination database query statement from said instance configuration pertaining to the table instance X I , wherein the destination database query statement is configured to return data from the table T in the destination database D I in response to being performed; and

performing a destination database query on the destination database D I using the generated second database query statement, resulting in returning data from the table T in the destination database D I if the table T has been defined for destination database D I or in not returning data from the table T in the destination database D I if the table T has not been defined for destination database D I ,

wherein said performing the destination database query on the destination database D I results in not returning data from the table T in the destination database D I , wherein said defining the table T for the destination database D I comprises:

creating schema and determining metadata associated with the schema, wherein said schema and associated metadata define the table T in the destination database D I ,

wherein said determining metadata comprises performing a second database query on the source database S, resulting in returning the metadata from the source database S.

2. The method of claim 1 , wherein said transferring comprises:

selecting the instance X I from the source database S; and

inserting the selected instance X I into the defined table T of the destination database D I , wherein said determining and said selecting are implemented by a single database query statement.

3. A method for deploying computing infrastructure, comprising integrating computer-readable code into a computing system, wherein the code when executed by a processor of the computing system performs a process for transferring table instances X 1 , X 2 , . . . , X N of a table T from a source database S to destination databases D 1 , D 2 , . . . , D N , respectively, said N being at least 1, said process comprising for I=1 2, . . . , N:

determining whether the table T has been defined for destination database D I , and if said determining determines that the table T has not been defined for the destination database D I then defining the table T for the destination database D I ; and

transferring the instance X I of the N table instances from the source database S into the defined table T of the destination database D I ,

wherein the process further comprises prior to said determining whether the table T has been defined for destination database D I and prior to said transferring the instance X I :

specifying an instance configuration pertaining to the table instance X I , wherein the instance configuration consists of an instance variable of the table T in combination with a value of the instance variable, and wherein the instance variable defines a set of rows of the table T pertaining to the table instance X I ;

generating a first database query statement from said instance configuration pertaining to the table instance X I , wherein the first database query statement is configured to return the table instance X I from the table T in the source database S in response to being performed; and

performing a first source database query on the source database S using the generated first database query statement, resulting in returning the table instance X I from the table T in the source database.

wherein said determining whether the table T has been defined for destination database D I comprises:

generating a destination database query statement from said instance configuration pertaining to the table instance X I , wherein the destination database query statement is configured to return data from the table T in the destination database D I in response to being performed; and

performing a destination database query on the destination database D I using the generated second database query statement, resulting in returning data from the table T in the destination database D I if the table T has been defined for destination database D I or in not returning data from the table T in the destination database D I if the table T has not been defined for destination database D I ,

wherein said performing the destination database query on the destination database D I results in not returning data from the table T in the destination database D I , wherein said defining the table T for the destination database D I comprises:

creating schema and determining metadata associated with the schema, wherein said schema and associated metadata define the table T in the destination database D I ,

wherein said determining metadata comprises performing a second database query on the source database S, resulting in returning the metadata from the source database S.

4. The method of claim 3 wherein said transferring comprises:

selecting the instance X I from the source database S; and

inserting the selected instance X I into the defined table T of the destination database D I , wherein said determining and said selecting are implemented by a single database query statement.