March 13, 2003 at 12:51 pm
I have a project to replicate some of our data to a 3rd party database. The catch is the tables are not named the same nor are the columns. The replication will only be one-way, us to them.
Can SQL replication be used, when tables and columns are named different?
-Hutch
March 13, 2003 at 1:11 pm
With replication you can use a DTS package to transform the data before inserting it to the subscribers.
So you should create a DTS package to transform the data to fit to the 3rd party tables.
March 13, 2003 at 2:30 pm
I can create the DTS package how do you set that to be replicated?
I have a basic architecture; I would like to use simple table triggers but I would want the flexibility of changing refresh rates and the number of subscribers that replication offers.
Are there any articles on creating this? I checked BOL and didn’t find anything using dts and replication.
-Hutch
March 25, 2003 at 4:50 am
I guess if the replication is only one way, that is insert into ur tables should do the insert into there tables, then u can change the MS replciation procedures and do taht, have those procedures names in ur article for those tables, to be callled and put those procedures at the subscriber end, never tried that, but this is the wasy replication happens, just try it out
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply