>Is there a fast way or command to compare 2 database to have all the same record count in all the tables ?
>
>Thanks in advance.
Look at using sp_MSForEachTable
You can try running
execute sp_MSForEachTable 'declare @Cnt int select @Cnt = count(*) from ? print '' ?: '' + cast(@cnt as varchar(10)) '
and then compare the output.
Unfortunately, the tables are not in alphabetical order.
If it's not broken, fix it until it is.
My Blog