November 29, 2004 at 9:29 am
Hi, I'm new in Sql Server, I'm working with sql server 2000 Enterprise Edition and I want to know if it's possible to replicate a View. I've a View in a server and I want to replicate it in another different Server. Both Servers are running Sql Server 2000 Enterprise Edition. I' ve created a replication with the wizard but it's not working.
It's Possible to replicate a Single View without the tables or what do I've to do to Repicate the View.
Thank´s alot.
Sincerely
Er_Sql
November 29, 2004 at 2:59 pm
You can certainly replicate a view, but what you are replicating is the SQL definition of the view itself, not the data that's returned by the view. The view however will return an error on the subscriber without the underlying tables.
Your best bet is to replicate the tables that the view calls in addition to the view itself.
All should work fine then.
Scott Thornburg
Volt Information Sciences
December 2, 2004 at 8:28 am
You can replicate view and data (as if a table), if the view is indexed with a primary key.
Check Publishing Data and Database Objects in BOL for more info.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply