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.
--
Mr Joe says "Bad Dog"

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,


"Mr Joe" wrote: