October 8, 2003 at 8:13 am
Hi all,
I need to replicate views from SQL Server 2000 database to SQL SErver 7.0.
I have two questions:
1. Can do replicate the views between the two?
2. In order to replicate the view, will I need to replicate the table(s)
that the view references as well (I think so, but I am double checking)?
Thank you,
Sang
October 8, 2003 at 9:06 am
Yes and yes. Selecting a view just sends over the definition of the view, not the data the view represents. Changes to the view after the initial snapshot are not replicated. SQL2K to SQL7 works fine.
Andy
October 16, 2003 at 6:39 pm
Also,
You will want to use Snapshot replication for Views, SP's, and Functions(SQL 2K only) as you can simply update the snapshot and replicate it out.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply