copy all views

Answers

• RockWithNAV Member Posts: 1,171

  2017-02-08 Answer ✓

  Did you tried doing this
  
  Right click on your database Tasks->Generate scripts. SQL Server Management Studio is able to generate the CREATE scripts for you.
  
  After then you simple copy this script and execute it on the target server/database.

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  5
• kanika Member Posts: 247

  2017-02-09

  Thanks but it has complicated me a bit ...
  
  When executing the script of the views in sql2012 I got error because there were missing tables, I created a script with the tables and when I run it in sql2012 it gives me this error:
  Invalid Specification: Filegroup 'Data Filegroup 1'.

  0
• kanika Member Posts: 247

  2017-02-09

  Sorry, the filegroup theme is already solved, now I'm solving errors that it gives me when executing the script of the views

  0
• RockWithNAV Member Posts: 1,171

  2017-02-09 Answer ✓

  Hey Kanika,
  
  Ya once you executed the script then you need to manually resolve all sort of error coming though.

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  5