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 |
|
caid
Starting Member
10 Posts |
 Posted - 2005-02-17 : 22:10:00
|
| I'm attempting to replicate portions of a company database into a new reporting db.All the info I want for the reporting db at this point can be encapsulated in two views on the publisher.Is there a way I can publish just the info from those two views, or do I have to replicate over all the tables they reference and run the view from there? Or something else?Thanks.caid |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-18 : 08:29:33
|
| Views do not physically store data in SQL Server, you must replicate their underlying tables to have them show the replicated data. |
 |
|
|
|
|
|
simple Q: replication from a view