copy all views

kanika · 2017-02-08

Hi experts!!

How can I copy all views from one sql 2008 r2 database to another in sql 2012?

Thanks!!

RockWithNAV · 2017-02-08

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.

RockWithNAV · 2017-02-09

Hey Kanika,

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

RockWithNAV · 2017-02-08

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.

kanika · 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'.

kanika · 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

RockWithNAV · 2017-02-09

Hey Kanika,

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

copy all views

Best Answers

Answers

Categories