Finding The Row Count For All Files In An iSeries Library And All Tables In An SQL Server Database
Average Rating
5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
2 thoughts on “Finding The Row Count For All Files In An iSeries Library And All Tables In An SQL Server Database”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Quick Tip: IBM Navigator for i Default URL
This is a really quick one but I keep forgetting it: http://<SERVERNAME>:2004/ibm/console
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
Okay, so I know this is more than five years old and I have been searching the internet for a solution such as this one. I am in the midst of migrating AS400 DB2 data off an old mainframe we want to decommission and I also want to validate row counts between it and the new sql tables. Any other tips just let me know? thanks!
Hey, Brad. Glad you found this post. When I was up to my neck in migrations from AS/400 to SQL Server, these SQL statements were very handy in not only proving to myself that the migration went well but also to prove to the other stakeholders that the data migration was successful. Thanks for reaching out! Good luck in your project!