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

Show quoteHide quote

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

Show quoteHide quote

I would create a copy of my target database.
Do a comparison and synchronization between the source and target databases
recording the delta script.
All you need is the tool to do it. DB Ghost (htt6p://www.dbghost.com) is the
only tool that can say the delta script it produces always works this is due
to the way it creates it.

A quote from RedGates SQL Compare

Q:
The script that SQL Compare generates doesn't work. Why not?

A:
Although the scripts that SQL Compare generates work 99% (my analysis puts
this figure much lower although it does depend on your environment and I
cannot see how this figure could ever be correct) of the time, they are only
meant as a starting point.
You may have to do some tweaking of the scripts before running them.
Also, make sure you test them and backup any databases before running them.
If you find a situation in which SQL Compare does not work, please let us
know.

My analysis: Why get something that doesn't always work.

Show quoteHide quote

Hi Folks

Thanx for your thoughts.. I do not want to use third party software guys..
please help me to find other method using scripts...

regards

how to resolve deadlock issues
Differential and Transaction backup restore.
SQL brain twister
Maintanence Plans for Backups
SQL Server EM/Query Analyzer Access
List all the logins that have a certain privileges
Error 21776 [SQL DMO]
blocking alerts
Log shipping question
Windows cannot open this program since it has been disabled.