Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 validare data against database

Author  Topic 

sonnysingh
Starting Member

42 Posts

Posted - 2005-05-29 : 08:30:23
Hi All

I have situation.. where I have to do

- Validate Data from target Database against source Database
Structure before upgrade target database from source database.

I would like advise on it that which would be the ideal method to do this process??


Thanx in advance



SqlIndia

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-31 : 15:19:13
You haven't provided enough information for us to help. What kind of validation? Show us an example.

Tara
Go to Top of Page

donpolix
Yak Posting Veteran

97 Posts

Posted - 2005-06-01 : 15:25:43
Are you doing a migration and want to scrub/validate the data before transferring? You want it in one pass?
You might need to stage each process. Probably a DTS with validation scripts..

Donn Policarpio
Go to Top of Page
   

- Advertisement -