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 |
|
manju3606
Yak Posting Veteran
78 Posts |
 Posted - 2012-02-13 : 07:34:26
|
| Hi to all,I would like to know setting up transactional replication, in which i replicating single table columns into MANY tables. (sql 2008, enterprise)I have single table with many column I need to be able to replicat 5 columns to five tables. but those All the tables I would be replicating have the different structure...can any one please let me know what issues I need to be aware of? Any limitations? Any guidelines for how you set the replication up to accomplish this?Any help or insight would be MUCH appreciated.....Thank youManju |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-13 : 12:25:53
|
| You want to replicate 5 columns from a single table to 5 different tables on the subscribers -- 1 column per table?This is almost certainly a bad idea. To do it, you'd set up 5 publications, with column filters.It might make more sense to publish it to ONE table on the subscriber and create 5 views. |
 |
|
|
|
|
|
Need help on replication