Views are exported as tables in the destination database

Posted on 2005-04-28
Medium Priority
Last Modified: 2010-03-19
I have noticed, and other users have noticed, that occasionally a view will not be a view in the destination database, but rather is a table.  I believe part of the reason is a broken ownership chain in the source view; however, the users insist there are other times it happens.

Can someone please give me a comprehensive list (as much as possible) of the conditions that cause this behavior.

Question by:guillotj
1 Comment
LVL 28

Accepted Solution

rafrancisco earned 750 total points
ID: 13889275
If you use DTS Import/Export Wizard and you select the first option in the Specify Table Copy or Query, which is the Copy table(s) and view(s) from the source database, views will be exported as tables in the destination database.

But if you select the third option, Copy objects and data between SQL Server databases, it will export views as views in the destination database.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

850 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