I'm trying to "clone" the structure of one database to a new blank database. I can copy the tables over using the Transfer Sql server object without any problems. When I create a separate task "Transfer Sql server object" for the views (CopyAllViews set
to true or picking individual views), it always reports success however none of the views were copied. The same problem occurs when I attempt to copy stored procedures. Anyone have an idea of what's going wrong?
View Complete Post