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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Data Replication

Author  Topic 

samadhanpatil
Starting Member

1 Post

Posted - 2012-02-07 : 08:11:12
Hi All,

I am having one server and want same data on another server.
Can we do it with materialized view in SQL Server.
Please Suggest.


Thanks,
Sam

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-07 : 12:21:32
I'll publish the underlying tables and create views on subscriber.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-07 : 12:53:53
monthly? weekly? daily? hourly? real time?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -