Copying Views from on DB to another 1

[youngcougar]

Might be a simple solution, but I haven't found it yet.......when using a DTS package to copy a view from one server to another, the view will only copy to a table. Is it possible to copy a view to another view, or do I have to run the view scripts individually?

Any help would be appreciated!

 

[mrdenny]

You'll need to run the create view scripts individually.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[youngcougar]

Thank you mrdenny. Is there an explanation as to why, just for my own knowledge?

 

[mrdenny]

Frankly, I have no idea. I'm not sure why Microsoft designed it that way.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)