Hi all,

I need to transfer data of a production server (as400) which mutates 24
hours a day to a sql server 2000.
Since it is important that this transfer is right and complete. I want
to check with hash totals and recordcounts if the transfer was
allright.

What is the best way to do this? I tried to compare the totals before
and after the transfer, but this is not working because its possible
that somebody inserted a new record.

Hope somebody can help.

Can you compare keys?

How would you know that a row was valid for transfer to SQL Server? Is this
still not valid afterwards?

You could stage the rows to be moved on te AS400 so you are not comparing a
moving target with the SQL Server.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Annabel" <anke.ruigrok (AT) adecco (DOT) nl> wrote

<<Can you compare keys?>>
Yes I have keys which i can compare


<<How would you know that a row was valid for transfer to SQL Server?
Is this
still not valid afterwards? >>

Good point, I didn't think about that one yet.


<<You could stage the rows to be moved on te AS400 so you are not
comparing a
moving target with the SQL Server. >>
I am going to discuss this with our database administrator.

Thanks for thinking with me!