Solved

Copy data from a MS SQL View to a table on another SQL server

Posted on 2009-06-27
5
317 Views
Last Modified: 2012-05-07
Hi,
I have a view on one MS SQL server that I want to be copied to a table on another MS SQL server once a day. I'm not sure whether to use replciation or not. When I did is required me to replicate all the tables that the view referenced which is not what I want.
Any help much appreciated.
Thanks
0
Comment
Question by:browsw
5 Comments
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 24727524
check for OpenRowset in the BOL (books on line) to see if you can use it. You could then schedule a query to run once a day.
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24729027
You can do that by creating a linked server by using sp_addlinkedserver stored proc and then create the view as you would normally do.
Here is reference to the stored proc: http://msdn.microsoft.com/en-us/library/aa259589(SQL.80).aspx
Or, if you do not want to use the stored proc you can do that via GUI. In SSMS connect to the sql server>Expand "Server Objects> Right click "Linked Servers">select "New Linked Server".
Hope this helps.
P.
0
 

Author Closing Comment

by:browsw
ID: 31597534
Question not answered
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now