> Hello all!
>
> I am changing the collation on the database and doing a DTS package to
> copy all of the tables from one database to another. Can someone help
> with the script that can then (once DTS is done) compare row counts
> between the new and old database? Maybe just show the diferent tables
> or at least have that option, otherwise I would need the full database
> to database comparison with table name and the row count. We have 5000
> tables and manual comparison is not practical at this time as we are
> at the time crunch.
>

"Allan Mitchell" wrote:

> Hello George,
>
> Are you asking how to do this in DTS or in general?
>
> DTS has nothing built in and I do not think this is really the job for it
> either. I would be tempted to use something like Red-Gate's Data Compare
> or I would write a script to go against all tables in both databases that
> counted the rows and inserted them into a table. I would then compare tables
> with the same names that have different servers.
>
>
> Allan
>
> > Hello all!
> >
> > I am changing the collation on the database and doing a DTS package to
> > copy all of the tables from one database to another. Can someone help
> > with the script that can then (once DTS is done) compare row counts
> > between the new and old database? Maybe just show the diferent tables
> > or at least have that option, otherwise I would need the full database
> > to database comparison with table name and the row count. We have 5000
> > tables and manual comparison is not practical at this time as we are
> > at the time crunch.
> >
>
>