Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Record Count for Tables

By Kyle Van Andel,

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.

Total article views: 993 | Views in the last 30 days: 3
 
Related Articles
FORUM

How to create user in Oracle 9i

How to create user in Oracle 9i

FORUM

Creating DB link b/w Oracle and SQL server

Creating DB link b/w Oracle and SQL server

FORUM

Getting records created in a particular week

Getting records created in a particular week

FORUM

linked server to oracle

create table in oracle over linked server

FORUM

UPDATE statement that creates duplicate records

Problem with an UPDATE statement that creates duplicate records

Tags
miscellaneous    
 
Contribute