Query SQL For Integrity Data Testing For SwitchOver The Server

[wayyy (Wahyu Muhammad Nouval)]

How I Count All Rows From All Tables From Database UiPath ?

Can you Suggest The Documentation Or Just Give Me any Ideas To Count All Rows From Database UiPath ?

[Anil_G (Anil Gorthi)]

@wayyy

I believe this will help you

Query to list number of records in each table in a database

Cheers

[wayyy (Wahyu Muhammad Nouval)]

yahh it works and it helps me , thankyou

[ashokkarale]

@wayyy,

Use Database activities for this.

1. Use Connect Database to connect. Save the output as a Database Connection variable, e.g., dbConnection.
2. Use the “Execute Query” activity to run the SQL query that retrieves the list of table names. Save the output as a DataTable variable, e.g., dtTables.
   Use query:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE';

3. Loop through each table by using For Each row in data table activity and pass dtTables to get count of rows from each Table.
   Inside the loop, Use another “Execute Query” activity to execute the count query. Save the output as another DataTable, e.g., dtRowCount.
   SQL Query:

SELECT 'TableName' AS TableName, COUNT(*) AS RowCount FROM TableName

Append this dtRowCount to an datatable which is outside of the For Each.

That’s it. You will have row counts of all tables.

Thanks,
Ashok