Match tables / Merge data

• Cláudia Sousa Rego

  SSCommitted

  Points: 1780

  More actions

  June 30, 2005 at 5:33 pm

  #102619

  Hi!

  I have 2 DB. Both DB have 29 tables. The tables in both DB's have the same name.

  I need:

  1. Compare tables with the same name to see if the data is equal in both. What is the best way to do this? Is there some stored procedure or script?
  2. If tables do not match, that is, if they have diferent data i need merge data in one table only. How can i do this?

  Thanks!!

  Cláudia 

   

  ---

  Regards,

  Cláudia Rego

  www.footballbesttips.com

• Deni Kusdeni

  Default port

  Points: 1457

  More actions

  June 30, 2005 at 8:06 pm

  #570214

  You can create replication and choose the merge replication, because with this you can update the database in 2 side, in DB1 or DB2.

• Hilary Cotter

  SSCommitted

  Points: 1861

  More actions

  July 1, 2005 at 4:38 am

  #570269

  have a look at data compare for redgate - this product does this.

  also check this out

  http://groups-beta.google.com/group/microsoft.public.sqlserver.replication/msg/244d264f5b10be48?dmode=source&hl=en

  --

  Hilary Cotter

  Looking for a SQL Server replication book?

  http://www.nwsu.com/0974973602.html

  Looking for a FAQ on Indexing Services/SQL FTS

  http://www.indexserverfaq.com

• Cláudia Sousa Rego

  SSCommitted

  Points: 1780

  More actions

  July 1, 2005 at 5:14 am

  #570276

  I Hilary!

  To see if Table1 and Table 2 are equal I tried the folowing:

  1> use Carros

  2> go

  1> select ABS(binary_checksum(Table1.Marca, Table1.Cavalos)-binary_checksum(Table2.Marca, Table2.Cavalos))

  2> go

  Msg 195, Level 15, State 10, Server TORMENTAS, Line 1

  'binary_checksum' is not a recognized function name.

  Why i get this error??

  The syntax is correct?

  Thanks

  ---

  Regards,

  Cláudia Rego

  www.footballbesttips.com