Compare data difference between two database in SQLServer 2005

Hi,
I have too databases, their structures are completely same, with minor data
difference, I want to generate a patch SQL statements, not complete backup
by comparing them, thus I can synchronzie the out-dated database with that
script. Does SQLServer2005 provide thus functionality? Or there is other
tool I can use. Thank you
zlf
You can do it yourself if you link the servers, but it may take a good
amount of work. Easier might be to use a third party tool. Red-Gate's SQL
Data Compare is probably the most obvious choice...
http://www.red-gate.com/products/SQL_Data_Compare/index.htm

Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"zlf" <zlfcn@.hotmail.com> wrote in message
news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have too databases, their structures are completely same, with minor
> data difference, I want to generate a patch SQL statements, not complete
> backup by comparing them, thus I can synchronzie the out-dated database
> with that script. Does SQLServer2005 provide thus functionality? Or there
> is other tool I can use. Thank you
> zlf
>
|||On Jun 22, 1:57 pm, "Adam Machanic" <amacha...@.IHATESPAMgmail.com>
wrote:
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's SQL
> DataCompareis probably the most obvious choice...
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/bookDisplay.html?bID=10220
> "zlf" <z...@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>
>
> - Show quoted text -
Hi Zif,
another great choice is xSQL Softwares xSQL Data Compare which you can
get from http://www.xsqlsoftware.com - you don't just get 2 weeks of
free trial but you also have it free forever for smaller size
databases (up to a certain number of objects) as well as free with no
limitations for SQL Server Express databases.
Furthermore, we have a well document api (xSQL SDK) that allows you to
integrate the functionality in your own application if you want.
Hope this helps.
Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com
|||It works. Thank both of you
"Adam Machanic" <amachanic@.IHATESPAMgmail.com>
?:%23jF$gbPtHHA.2164@.TK2MSFTNGP02.phx.gbl...
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's
> SQL Data Compare is probably the most obvious choice...
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>