Predicting scale of data migration

A system for predicting an amount of data storage needed when moving data from primary data storage to secondary or archive data storage, the system comprising:

• one or more non-transitory, computer-readable mediums having computer-executable instructions stored thereon;
• and,
• one or more processors that, having executed the computer-executable instructions, configure the system to perform a plurality of operations comprising:
• receiving a request to move data from a primary data storage system to a secondary data storage system;
• translating the request to a nested database query based on a database schema, wherein translating the request comprises referencing the database schema to determine which tables are to be queried to satisfy the request to move data;
• predicting a size of data that will be returned as a result of executing the nested database query;
• and,
• providing the predicted size before moving the data from the primary data storage system to the secondary data storage system.

A non-transitory, computer-readable medium having computer-executable instructions stored thereon that, when executed by one or more processors, causes a system to perform a method for predicting an amount of data storage needed when moving data from primary data storage to secondary or archive data storage, the method comprising:

• receiving a request to move data from a primary data storage system to a secondary data storage system;
• translating the request to a nested database query based on a database schema, wherein translating the request comprises referencing the database schema to determine which tables are to be queried to satisfy the request to move data;
• predicting a size of data that will be returned as a result of executing the nested database query;
• and,
• providing the predicted size before moving the data from the primary data storage system to the secondary data storage system.