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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Using Publication to synchronize different table

Author  Topic  nodje Starting Member 6 Posts Posted - 2005-12-01 : 06:34:00 Hi everyone, I've never use the publication mecanism and would like to give it a try. I have to synchronize tables two databases. This tables are different: the column names are in different languages, but the types are identical. I would like to avoid manually writing a script. The merging process is quite difficult to implement. I realized the publication process is able to do such merge. I've tried to implement this using all possible tricks (views and articles filter) but it seems that SQLServer is only able to synchronize homogenous data. Anyone having experienced this? Any tip welcome! -- nodje