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 |
|
Liat001
Starting Member
17 Posts |
 Posted - 2010-07-25 : 08:24:30
|
| Hi All,I have a situation where need to setup a publisher and subscriber but the table structure does not match between source and destination DB.The Publisher has four columns and subscriber has five columns. Result:The replication failedWhy? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-07-25 : 13:53:45
|
| you can use column filters to replicate only the 4 columns on your pubilsher table... check out books online for more info on column filters..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
parody
Posting Yak Master
111 Posts |
Posted - 2010-07-26 : 08:50:57
|
| I think he means the other way around... source has 4 columns. Also I believe a filter is horizontal not vertical, that would just be which columns you select.I dont think there is a way to do it this way round, at least we have tried before and ended up using an SSIS instead.If there is a way I would be interested to find out! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-26 : 13:41:54
|
There is a workaround. Not really a workaround as it works with normal procedures:Make sure the extra column at the subscriber is nullable.Can also set the article properties at the publisher, before running the snapshot, to leave subscriber article(s) unchanged. But 1st you need to make sure the extra column is nullable. |
|
|
|
|
|
|
Replication