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 |
|
olandese
Starting Member
1 Post |
 Posted - 2006-01-12 : 10:02:31
|
| Hello,i have setup a transactional publication and replication in SQL 2000.I want to put data (in a transactional way of course) from DB A (Publisher) to db B (subscriber).The problem is that in DB A there are more tables, and i want to put all the data from those tables into ONE table in DB B. I tried to do this with DTS, but when i make a package that make this possible i cannot see it from the subscription wizard. Is possible to make this kind of transformable subscription, can someone help me please?I need it for a realtime application, so the data has to be replicated in a transactional way. |
|
|
CorpDirect
Yak Posting Veteran
92 Posts |
Posted - 2006-01-18 : 09:52:32
|
| Though I'm fairly new to replication myself, I don't think it can be used in this way. Replication is used to "replicate" -- think "duplicate" -- objects (using snapshots) or changes (using transactions) from the publisher to the subscriber.While you can filter what gets replicated, I don't think you can actually replicate data from many tables to one. |
 |
|
|
|
|
|
Transformable subscription