I am trying to compare the data in 4 different instances of 2 databases. 2 are in SQL Server and the other 6 are in Snowflake. I am not trying to get to row level just a high level. The best I have come up with is below. I am wondering if there is a better way the writing out the scripts, by that I mean getting the list of tables and looping through doing a COUNT(), "table name", COUNT(), UNION ... then compare the 2 list sto see which tables/views are missing and which counts are off. Am I going to blow up my servers? I almost feel like I should be able to do this real easy in Python. Right now my plan is just to run a script to list all the items in the database then use Excel to write all the SELECT COUNT(*) FROM [TABLENAME] UNION ALL and then have another for the Snowflake style. Maybe this is the easiest. Something like: Table/View Lists Table Counts Function List Continue reading...
