This script was created for an Oracle to SQL 2005 migration. It creates a table, and then populates it with the record counts for each table in a given schema. (You will need to replace the xxxx text with your schema name for it to work). I prefer populating a table with this data, then creating a linked server to the Oracle box to match up the record counts with a similar script I ran on the Oracle side, allowing me to easily check that all records were migrated.
2007-10-02 (first published: 2002-06-20)
15,443 reads