sql server dts: Importing views -- sql server dts

Importing views

Mr Joe
5/28/2006 7:02:01 AM

sql server dts:

I'm trying to import user views from db to another. When I use the copy table
and views option and select only the views it appears to copy fine and says
so but the views don't show up in the destination. When I use copy objects
and select only the view it generates an error that states "There is already
an object named 'viewName' in the database. But ofcourse its not there.
Anyone have any ideas what the %$#^%$ is going on.
--

RE: Importing views

Shiva naidu
5/30/2006 1:23:02 AM

Hi Joe,

This is a problem when you import the views from one DB to other

The Import/Export wizard will create the views in the form of tables not
views so if you try to view the name it will say as a User table,

Now you have to drop the tables with the view name and then script the views
and execute them on the destination server,

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.