validate data of target database against source database structure..How?

Hi All

I need to

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

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


Thanx in advance

Hi,

SQLCompare is great utility to compare and vaidate data structure and data.
This product is from Redgate software.

http://www.red-gate.com/SQL_Compare.htm

Thanks
Hari
SQL Server MVP

"sonny singh via webservertalk.com" <forum@nospam.webservertalk.com> wrote i
n
message  news:9dafd28b7cd1437
 bbecb36b8c2a01a1e@we
bservertalk.com...
> Hi All
>
> I need to
>
> - Validate Data from target Database against source Database
> Structure before upgrade target database from source database.
>
> I would like have advise on it that which would be the ideal method to do
> this process??
>
>
> Thanx in advance

Definitely Red Gate... It's not too expensive either.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"sonny singh via webservertalk.com" <forum@nospam.webservertalk.com> wrote i
n
message  news:9dafd28b7cd1437
 bbecb36b8c2a01a1e@we
bservertalk.com...
> Hi All
>
> I need to
>
> - Validate Data from target Database against source Database
> Structure before upgrade target database from source database.
>
> I would like have advise on it that which would be the ideal method to do
> this process??
>
>
> Thanx in advance