title: How to copy views from one database to another database
body: <p>I have two databases with same structure in MS SQL server.</p>
  
  <p>I'd like to copy all views another database.</p>
  
  <p>I tried to use Export data functionality by DTS (that works with the table objects).</p>
  
  <p>But that executes the SQL &amp; creates the table object.</p>
  
  <p>I don't want to execute that just want to copy the view so that I can open them in design view.</p>
  
  <p>I tried to use create new view in destination database &amp; copy SQL query of the view of the source database &amp; save the view.
  That works works exactly same that I want, But I have number of views &amp; number of copies!</p>