SQL Server Performance

Views 2008

Discussion in 'ALL SQL SERVER QUESTIONS' started by Ather, Apr 22, 2013.

?

problem in transfering Views

sql server 2008 0 vote(s) 0.0%
sql 2008 0 vote(s) 0.0%
  1. Ather New Member

    i am using sql 2008 n transfering data from "tools>export data" from a remote server to my local server, all the tables are transfering perfectly but views are transfering in the tables not in the views. can any one help me
  2. FrankKalis Moderator

    I might be wrong, but views are "virtual tables" that usually only materialise when queried. So when you export data from a view's result set, it makes sense to create a new table based on this result set. It seems you only want the view's definition to be transferred, not the actual result set.
    Ather likes this.

Share This Page