Re: How to check datatransfer AS400 Production database to SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

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@xxxxxxxxx> wrote in message
news:1123253928.984949.71800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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.
>


.

Relevant Pages

  • Re: File Auditing - Fast DB import and data manipulation
    ... the files into the database is not the best way forward. ... on either system (you'll need to download gunzip from gnuwin32 ... The databases I've dealt with (Oracle, SQL Server, Access, Postgres) ... So, I need some way to compare todays file, to yesterdays and see ...
    (comp.lang.ruby)
  • Re: Import LATEST Excel file using DTS
    ... Subsequent files - compare time variable to this file's ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ... > Dim lobjFileObject ... > Set lobjFiles = lobjFolder.Files ...
    (microsoft.public.sqlserver.dts)
  • Re: Database Compare Application help needed
    ... of the work should be done within SQL Server. ... > I have to write a .Net application which can compare SQL Databases ... > in VB.6.0 but I have to design a C#.net application using the latest SQL ... > if anyone know what objects are available in .net to compare databases I ...
    (microsoft.public.dotnet.general)
  • Re: tool for stored proc. (written in oracle/sql) execution?
    ... > obtained after execution of stored procedure in oracle and sql? ... I have migrated my stored procedure written in sql 2000 to ... use a simple file compare utility (like the fc.exe command line utility ... from the SQL Server into a table with a unique index on all columns and try ...
    (microsoft.public.sqlserver.tools)
  • Compare 2 datasets?
    ... I have a simple project that requires I take a set of data from an Excel ... spreadsheet, compare it to a table in SQL Server, ... but is otherwise identical to the spreadsheet. ...
    (microsoft.public.dotnet.languages.csharp)