Add single table load progress column to table statistics tab

0

It would be useful while full load is running to see in "Table Statistics" tab each table estimated progress in percentage ([target loaded rows]/[source_table_row_count]*100) based on the source table row count returning from this query on the source DB:

SQL Server:

SELECT SUM(row_count) AS source_table_row_count FROM sys.dm_db_partition_stats WHERE OBJECT_NAME(object_id)='table name' and index_id < 2 GROUP BY OBJECT_NAME(object_id);

Oracle:

SELECT num_rows AS source_table_row_count from all_tables where owner='schema name' and table_name='table name'

MySQL:

select table_rows AS source_table_row_count from information_schema.tables where table_schema='schema name' and table_name='table name'

PostgreSQL:

SELECT c.reltuples::bigint AS AS source_table_row_count FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace where n.nspname='schema name' and c.relname='table name' order by 1,2 ;

1 Answer
0

Adding a single table load progress column to the table statistics tab in AWS Database Migration Service (DMS) would be a helpful feature. The estimated progress in percentage would allow users to track the progress of individual tables during the full load process.

As you mentioned, the source table row count can be obtained using different queries depending on the database platform. AWS DMS supports PostgreSQL, Oracle, Microsoft SQL Server, MySQL, and other database platforms, so it would need to handle the different query formats appropriately.

hash
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions