Create Views that Includes tables from another server

• dean gross

  SSCrazy

  Points: 2632

  More actions

  June 1, 2007 at 7:35 am

  #178865

  I have SQL 2005 Management studio on my dev machine and productions DBs on other servers that I can READ from. I'd like to be able to create views that select data from the production dbs and store the views on my PC in a development DB. What is the best way to do this?

• Anders Pedersen

  SSChampion

  Points: 11410

  More actions

  June 1, 2007 at 7:46 am

  #710333

  (not that I recommend this, but..)

  Create a linked server from your development machine to the production server and use that to create the views.

  Are you really sure you want to burden your production machine with queries from the development machine?