Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bluisana
Starting Member
2 Posts |
 Posted - 2005-02-02 : 16:00:12
|
| 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 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-02 : 19:57:54
|
| I'm not a replication whiz, but I believe differing schemas are not supportable under any kind of replication. It's certainly not recommended. And merge replication, generally speaking, should be the last consideration; it is the trickiest and most difficult type to get working.You would probably be best off using Data Transformation Services (DTS) for your project, it is specifically designed to move, transform, and re-map data between databases. Books Online will get you started (check the Contents tab for "Data Transformation Services") |
 |
|
|
bluisana
Starting Member
2 Posts |
Posted - 2005-02-03 : 08:51:59
|
| That is what I thougt. I just confirm that wasn't the route to take. Thanks for the info. |
|
|
|
|
|
|
Merge Replicaiton with different schemas?