copy all views

kanika

Hi experts!!

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

Thanks!!

RockWithNAV

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

Hey Kanika,

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

RockWithNAV

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

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

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

RockWithNAV

Hey Kanika,

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