Comparing table structures.

Hi all,

Could anyone let me know if there are any Scripts available for comparing the schema differences between two SQL server databases?

Thanks

DBAnalyst

I once made a script for that, feel free to contact me if I should send it over.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Please send it Jens, Thanks a lot.sqlsql

Comparing table structures between databases

Unfortunatly no there isn't an easy way.
If you have connection to the internet log on to the site
http://www.adeptsql.com/download.htm and download AdeptSQL
Diff ver 1.6.
We have used that for all our server and works very well.
N.B. You can program it yourself in SQL but will take a
bit of time, and this will hi-light every difference.
Peter
"What makes him think a middle aged actor [Clint
Eastwood], who's played with a chimp, could have a future
in politics?"
Ronald Reagan

>--Original Message--
>What is the easiest way to compare the table structure of
two databases?
>I have inherited a project and have found a couple of
undocumented
>inconsistencies between the development and production
databases.
>Is there an in-built function or a utility that can help
with this?
>Thanks,
>Mike
>
>.
>
Thanks, Peter.
That looks like it will do all I need and more.
Regards,
Mike
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:4bbe01c490da$17ef8560$a601280a@.phx.gbl...[vbcol=seagreen]
> Unfortunatly no there isn't an easy way.
> If you have connection to the internet log on to the site
> http://www.adeptsql.com/download.htm and download AdeptSQL
> Diff ver 1.6.
> We have used that for all our server and works very well.
> N.B. You can program it yourself in SQL but will take a
> bit of time, and this will hi-light every difference.
> Peter
> "What makes him think a middle aged actor [Clint
> Eastwood], who's played with a chimp, could have a future
> in politics?"
> Ronald Reagan
>
> two databases?
> undocumented
> databases.
> with this?

Comparing table structures between databases

What is the easiest way to compare the table structure of two databases?
I have inherited a project and have found a couple of undocumented
inconsistencies between the development and production databases.
Is there an in-built function or a utility that can help with this?
Thanks,
MikeUnfortunatly no there isn't an easy way.
If you have connection to the internet log on to the site
http://www.adeptsql.com/download.htm and download AdeptSQL
Diff ver 1.6.
We have used that for all our server and works very well.
N.B. You can program it yourself in SQL but will take a
bit of time, and this will hi-light every difference.
Peter
"What makes him think a middle aged actor [Clint
Eastwood], who's played with a chimp, could have a future
in politics?"
Ronald Reagan
>--Original Message--
>What is the easiest way to compare the table structure of
two databases?
>I have inherited a project and have found a couple of
undocumented
>inconsistencies between the development and production
databases.
>Is there an in-built function or a utility that can help
with this?
>Thanks,
>Mike
>
>.
>|||Thanks, Peter.
That looks like it will do all I need and more.
Regards,
Mike
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:4bbe01c490da$17ef8560$a601280a@.phx.gbl...
> Unfortunatly no there isn't an easy way.
> If you have connection to the internet log on to the site
> http://www.adeptsql.com/download.htm and download AdeptSQL
> Diff ver 1.6.
> We have used that for all our server and works very well.
> N.B. You can program it yourself in SQL but will take a
> bit of time, and this will hi-light every difference.
> Peter
> "What makes him think a middle aged actor [Clint
> Eastwood], who's played with a chimp, could have a future
> in politics?"
> Ronald Reagan
>
> >--Original Message--
> >What is the easiest way to compare the table structure of
> two databases?
> >
> >I have inherited a project and have found a couple of
> undocumented
> >inconsistencies between the development and production
> databases.
> >
> >Is there an in-built function or a utility that can help
> with this?
> >
> >Thanks,
> >
> >Mike
> >
> >
> >.
> >

Comparing table structures between databases

What is the easiest way to compare the table structure of two databases?
I have inherited a project and have found a couple of undocumented
inconsistencies between the development and production databases.
Is there an in-built function or a utility that can help with this?
Thanks,
MikeThanks, Peter.
That looks like it will do all I need and more.
Regards,
Mike
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:4bbe01c490da$17ef8560$a601280a@.phx.gbl...[vbcol=seagreen]
> Unfortunatly no there isn't an easy way.
> If you have connection to the internet log on to the site
> http://www.adeptsql.com/download.htm and download AdeptSQL
> Diff ver 1.6.
> We have used that for all our server and works very well.
> N.B. You can program it yourself in SQL but will take a
> bit of time, and this will hi-light every difference.
> Peter
> "What makes him think a middle aged actor [Clint
> Eastwood], who's played with a chimp, could have a future
> in politics?"
> Ronald Reagan
>
> two databases?
> undocumented
> databases.
> with this?

Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
GasparHello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar

Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
Gaspar
Hello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar
sqlsql

Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
Gaspar
Hello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar

Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
GasparHello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar

Comparing database structures

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
comparison between an up-to-date version and an older version of the same
database. However, when I try to synchronize, it synchronizes the normal
tables, then I get a message:
The following error message was returned from the SQL Server:
[208] Invalid object name 'dbo.MSmerge_contents'.
The following SQL command caused the error:
create view [MSmerge_contents_Products] as select * from
dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
(select rowguid from [Products]))
I have limited familiarity with the MSmerge_contents tables, but if I recall
correctly, those are tables used during replication. I've done no
replication on either of these datatabases, although it is possible that one
or the other was derived from a database that had been replicated at one
time. To make a long story short, both of these being non-replicated
databases, any problems just dropping those tables?
1) Can't you have SQLCompare ignore system objects when doing a comparison?
2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
or have cross-platform needs, check out Embarcadero's Change Manager.
TheSQLGuru
President
Indicium Resources, Inc.
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
> comparison between an up-to-date version and an older version of the same
> database. However, when I try to synchronize, it synchronizes the normal
> tables, then I get a message:
> The following error message was returned from the SQL Server:
> [208] Invalid object name 'dbo.MSmerge_contents'.
> The following SQL command caused the error:
> create view [MSmerge_contents_Products] as select * from
> dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
> (select rowguid from [Products]))
> I have limited familiarity with the MSmerge_contents tables, but if I
> recall correctly, those are tables used during replication. I've done no
> replication on either of these datatabases, although it is possible that
> one or the other was derived from a database that had been replicated at
> one time. To make a long story short, both of these being non-replicated
> databases, any problems just dropping those tables?
>
|||Thanks for the references, I'll certainly check out those products. The
SQLCompare did allow me to ignore the differences on synchronization, which
was enough to finish the job.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OK0ZsF5cHHA.284@.TK2MSFTNGP05.phx.gbl...
> 1) Can't you have SQLCompare ignore system objects when doing a
> comparison?
> 2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
> or have cross-platform needs, check out Embarcadero's Change Manager.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>

Comparing database structures

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
comparison between an up-to-date version and an older version of the same
database. However, when I try to synchronize, it synchronizes the normal
tables, then I get a message:
The following error message was returned from the SQL Server:
[208] Invalid object name 'dbo.MSmerge_contents'.
The following SQL command caused the error:
create view [MSmerge_contents_Products] as select * from
dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
(select rowguid from [Products]))
I have limited familiarity with the MSmerge_contents tables, but if I recall
correctly, those are tables used during replication. I've done no
replication on either of these datatabases, although it is possible that one
or the other was derived from a database that had been replicated at one
time. To make a long story short, both of these being non-replicated
databases, any problems just dropping those tables?1) Can't you have SQLCompare ignore system objects when doing a comparison?
2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
or have cross-platform needs, check out Embarcadero's Change Manager.
TheSQLGuru
President
Indicium Resources, Inc.
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
> comparison between an up-to-date version and an older version of the same
> database. However, when I try to synchronize, it synchronizes the normal
> tables, then I get a message:
> The following error message was returned from the SQL Server:
> [208] Invalid object name 'dbo.MSmerge_contents'.
> The following SQL command caused the error:
> create view [MSmerge_contents_Products] as select * from
> dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
> (select rowguid from [Products]))
> I have limited familiarity with the MSmerge_contents tables, but if I
> recall correctly, those are tables used during replication. I've done no
> replication on either of these datatabases, although it is possible that
> one or the other was derived from a database that had been replicated at
> one time. To make a long story short, both of these being non-replicated
> databases, any problems just dropping those tables?
>|||Thanks for the references, I'll certainly check out those products. The
SQLCompare did allow me to ignore the differences on synchronization, which
was enough to finish the job.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OK0ZsF5cHHA.284@.TK2MSFTNGP05.phx.gbl...
> 1) Can't you have SQLCompare ignore system objects when doing a
> comparison?
> 2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
> or have cross-platform needs, check out Embarcadero's Change Manager.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>

Comparing database structures

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
comparison between an up-to-date version and an older version of the same
database. However, when I try to synchronize, it synchronizes the normal
tables, then I get a message:
The following error message was returned from the SQL Server:
[208] Invalid object name 'dbo.MSmerge_contents'.
The following SQL command caused the error:
create view [MSmerge_contents_Products] as select * from
dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
(select rowguid from [Products]))
I have limited familiarity with the MSmerge_contents tables, but if I recall
correctly, those are tables used during replication. I've done no
replication on either of these datatabases, although it is possible that one
or the other was derived from a database that had been replicated at one
time. To make a long story short, both of these being non-replicated
databases, any problems just dropping those tables?1) Can't you have SQLCompare ignore system objects when doing a comparison?
2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
or have cross-platform needs, check out Embarcadero's Change Manager.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
> comparison between an up-to-date version and an older version of the same
> database. However, when I try to synchronize, it synchronizes the normal
> tables, then I get a message:
> The following error message was returned from the SQL Server:
> [208] Invalid object name 'dbo.MSmerge_contents'.
> The following SQL command caused the error:
> create view [MSmerge_contents_Products] as select * from
> dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
> (select rowguid from [Products]))
> I have limited familiarity with the MSmerge_contents tables, but if I
> recall correctly, those are tables used during replication. I've done no
> replication on either of these datatabases, although it is possible that
> one or the other was derived from a database that had been replicated at
> one time. To make a long story short, both of these being non-replicated
> databases, any problems just dropping those tables?
>|||Thanks for the references, I'll certainly check out those products. The
SQLCompare did allow me to ignore the differences on synchronization, which
was enough to finish the job.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OK0ZsF5cHHA.284@.TK2MSFTNGP05.phx.gbl...
> 1) Can't you have SQLCompare ignore system objects when doing a
> comparison?
> 2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
> or have cross-platform needs, check out Embarcadero's Change Manager.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>> I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
>> comparison between an up-to-date version and an older version of the same
>> database. However, when I try to synchronize, it synchronizes the normal
>> tables, then I get a message:
>> The following error message was returned from the SQL Server:
>> [208] Invalid object name 'dbo.MSmerge_contents'.
>> The following SQL command caused the error:
>> create view [MSmerge_contents_Products] as select * from
>> dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
>> (select rowguid from [Products]))
>> I have limited familiarity with the MSmerge_contents tables, but if I
>> recall correctly, those are tables used during replication. I've done no
>> replication on either of these datatabases, although it is possible that
>> one or the other was derived from a database that had been replicated at
>> one time. To make a long story short, both of these being non-replicated
>> databases, any problems just dropping those tables?
>sqlsql

Comparing database structures

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
comparison between an up-to-date version and an older version of the same
database. However, when I try to synchronize, it synchronizes the normal
tables, then I get a message:
The following error message was returned from the SQL Server:
[208] Invalid object name 'dbo.MSmerge_contents'.
The following SQL command caused the error:
create view [MSmerge_contents_Products] as select * from
dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
(select rowguid from [Products]))
I have limited familiarity with the MSmerge_contents tables, but if I recall
correctly, those are tables used during replication. I've done no
replication on either of these datatabases, although it is possible that one
or the other was derived from a database that had been replicated at one
time. To make a long story short, both of these being non-replicated
databases, any problems just dropping those tables?
1) Can't you have SQLCompare ignore system objects when doing a comparison?
2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
or have cross-platform needs, check out Embarcadero's Change Manager.
TheSQLGuru
President
Indicium Resources, Inc.
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
> comparison between an up-to-date version and an older version of the same
> database. However, when I try to synchronize, it synchronizes the normal
> tables, then I get a message:
> The following error message was returned from the SQL Server:
> [208] Invalid object name 'dbo.MSmerge_contents'.
> The following SQL command caused the error:
> create view [MSmerge_contents_Products] as select * from
> dbo.MSmerge_contents where (tablenick = 4976004 and rowguid in
> (select rowguid from [Products]))
> I have limited familiarity with the MSmerge_contents tables, but if I
> recall correctly, those are tables used during replication. I've done no
> replication on either of these datatabases, although it is possible that
> one or the other was derived from a database that had been replicated at
> one time. To make a long story short, both of these being non-replicated
> databases, any problems just dropping those tables?
>
|||Thanks for the references, I'll certainly check out those products. The
SQLCompare did allow me to ignore the differences on synchronization, which
was enough to finish the job.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OK0ZsF5cHHA.284@.TK2MSFTNGP05.phx.gbl...
> 1) Can't you have SQLCompare ignore system objects when doing a
> comparison?
> 2) Check out ApexSQL's Diff product. Or if you want to pay a lot of money
> or have cross-platform needs, check out Embarcadero's Change Manager.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:extQYmzcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>

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

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
zlfYou 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/SQ...mpare/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 SQ
L
> DataCompareis probably the most obvious choice...
> http://www.red-gate.com/products/SQ...mpare/index.htm
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/boo
kDisplay.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/SQ...mpare/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...
>

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
zlfYou 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...
>
> > Hi,
> > I have toodatabases, 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- Hide quoted text -
> - 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...
>> 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
>