KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have two databases with same structure in MS SQL server. I'd like to copy all views another database. I tried to use Export data functionality by DTS (that works with the table objects). But that executes the SQL & creates the table object. I don't want to execute that just want to copy the view so that I can open them in design view. I tried to use create new view in destination database & copy SQL query of the view of the source database & save the view. That works works exactly same that I want, But I have number of views & number of copies!
Tags (comma-separated)
Save Edits
Cancel