Exporting subset of a database

1. A method for exporting a subset of a database, the method comprising:

receiving a request to export a subset of data of a source database from a source system to a target database in a target system, the request specifying a criterion for determining the subset, the subset of data being represented in a plurality of tables, the plurality of tables being stored in a plurality of files within the source system;

dividing the plurality of tables into a first set of tables and a second set of tables;

exporting the first set of tables to the target system by identifying one or more files in the plurality of files that store the first set of tables and transferring the one or more files to the target database in the target system by performing a file copy operation of the source system; and

exporting a portion of the subset of data represented in the second set of tables to the target system by executing one or more database queries on the second set of tables based on the criterion and transferring the portion of the subset of data represented in the second set of tables to the target database, wherein the second set of tables comprises each of the plurality of tables except the tables comprising the first set of tables.

2. The method of claim 1 , wherein the second set of tables comprises a fixed number of largest database tables of the source database.

3. The method of claim 1 , further comprising:

creating a new table space in the source database; and

transferring the second set of tables to the new table space.

4. The method of claim 3 , wherein identifying one or more files in the plurality of files that store the first set of tables comprises:

identifying a file storing data of the new table space; and

selecting files storing data of the source database other than the identified file.

5. The method of claim 1 , wherein the file copy operation is performed by executing an operating system command to transfer files on the source system.

6. The method of claim 1 , wherein the file copy operation is performed without invoking a database query of the source database.

7. The method of claim 1 , wherein the source database system is associated with an application, the method further comprising:

identifying one or more application files stored on the source system, the one or more files storing information associated with the application; and

copying the one or more application files to the target system.

8. The method of claim 7 , further comprising:

invoking one or more scripts to modify the application files to configure the application on the target system to use the target database.

9. The method of claim 1 , wherein dividing the plurality of tables into a first set of tables and a second set of tables comprises:

assigning any tables in the plurality of tables for which a computational cost associated with executing the one or more database queries exceeds a computational cost associated with performing a file copy operation to the first set of tables; and

assigning any remaining tables in the plurality of tables to the second set of tables.

10. The method of claim 9 , wherein the score of a table is based on at least one of: a size of data stored in the table, how frequently the table is accessed, how frequently the table is updated, or a measure of significance of the table supplied by an administrator.

11. The method of claim 1 , wherein the number of tables in the second set of tables is less than the number of tables in the first set of tables.

12. At least one non-transitory computer-readable medium storing computer-readable instructions that, when executed by one or more computing devices, cause at least one of the one or more computing devices to:

receive a request to export a subset of data of a source database from a source system to a target database in a target system, the request specifying a criterion for determining the subset, the subset of data being represented in a plurality of tables, the plurality of tables being stored in a plurality of files within the source system;

divide the plurality of tables into a first set of tables and a second set of tables;

export the first set of tables to the target system by identifying one or more files in the plurality of files that store the first set of tables and transferring the one or more files to the target database in the target system by performing a file copy operation of the source system; and

export a portion of the subset of data represented in the second set of tables to the target system by executing one or more database queries on the second set of tables based on the criterion and transferring the portion of the subset of data represented in the second set of tables to the target database, wherein the second set of tables comprises each of the plurality of tables except the tables comprising the first set of tables.

13. The at least one non-transitory computer-readable medium of claim 12 , wherein the second set of tables comprises a fixed number of largest database tables of the source database.

14. The at least one non-transitory computer-readable medium of claim 12 , further storing computer-readable instructions that, when executed by at least one of the one or more computing devices, cause at least one of the one or more computing devices to:

creating a new table space in the source database; and

transferring the second set of tables to the new table space.

15. The at least one non-transitory computer-readable medium of claim 14 , wherein the instructions that, when executed by at least one of the one or more computing devices, cause at least one of the one or more computing devices to identify one or more files in the plurality of files that store the first set of tables further cause at least one of the one or more computing devices to:

identifying a file storing data of the new table space; and

selecting files storing data of the source database other than the identified file.

16. The at least one non-transitory computer-readable medium of claim 12 , wherein the file copy operation is performed by executing an operating system command to transfer files on the source system.

17. The at least one non-transitory computer-readable medium of claim 12 , wherein the file copy operation is performed without invoking a database query of the source database.

18. The at least one non-transitory computer-readable medium of claim 12 , wherein the source database system is associated with an application, further storing computer-readable instructions that, when executed by at least one of the one or more computing devices, cause at least one of the one or more computing devices to:

identifying one or more application files stored on the file system of the source database, the one or more files storing information associated with the application; and

copying the one or more application files to the target system.

19. The at least one non-transitory computer-readable medium of claim 18 , further storing computer-readable instructions that, when executed by at least one of the one or more computing devices, cause at least one of the one or more computing devices to:

invoking one or more scripts to modify the application files to configure the application on the target system to use the target database.

20. A computer-implemented system for exporting a subset of a database, the system comprising:

one or more processors; and

one or more memories operatively coupled to at least one of the one or more processors and having instructions stored thereon that, when executed by at least one of the one or more processors, cause at least one of the one or more processors to:

receive a request to export a subset of data of a source database from a source system to a target database in a target system, the request specifying a criterion for determining the subset, the subset of data being represented in a plurality of tables, the plurality of tables being stored in a plurality of files within the source system;

divide the plurality of tables into a first set of tables and a second set of tables;

export the first set of tables to the target system by identifying one or more files in the plurality of files that store the first set of tables and transferring the one or more files to the target database in the target system by performing a file copy operation of the source system; and

export a portion of the subset of data represented in the second set of tables to the target system by executing one or more database queries on the second set of tables based on the criterion and transferring the portion of the subset of data represented in the second set of tables to the target database, wherein the second set of tables comprises each of the plurality of tables except the tables comprising the first set of tables.