• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

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

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.
1 Solution
Éric MoreauSenior .Net ConsultantCommented:
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.
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.
browswAuthor Commented:
Question not answered
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now