Home > Archive > MS SQL Server > May 2005 > validate data of target database against source database structure..How?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author validate data of target database against source database structure..How?
sonny singh via SQLMonster.com

2005-05-29, 9:23 am

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
Hari Prasad

2005-05-29, 9:23 am

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 in
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



Wayne Snyder

2005-05-30, 7:23 am

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 in
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



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com