Merge replication question 1

[intrex]

Hello,

I am fairly new to merge repliction.

I am trying to keep data synchronized between 2 databases that have completely different schemas. Is merge replication flexible enough that it will allow me to map fields in each database that I want merged?

I have a few other ideas of how to do this but they involve writing alot of custom code. Do I have any other options to accomplish this?

Thanks for your time,

Bryan Luisana

 

[mrdenny]

Replication can handle some Schema changes between servers. It all depends on just how major the schema changes are. Can you provide examples?


Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[intrex]

The merge will basiclly touch 2 tables one database and one table on another. The field names from each database are different thought.

ex: database(1) table(1) column names: partnum, desc
table(2) column names: label, skid
database(2) column names: item_id, partdesc, lbl, skidqty

It should be no more complicated that maping field names and maybe one join.

 

[mrdenny]

What you are looking to do, I don't think that Replication can handle. Could you pass the data over in the origional schema, and use a view to handle the combinning for the application using the data from database 2?

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[intrex]

After looking deeper into replication, I think that I am going to have to build a custom application, use a DTS package, or use triggers.