| mark baekdal 2005-05-30, 9:23 am |
| 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.
"sonny singh via webservertalk.com" wrote:
> 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
>
|