1

I have a SQL Server 2012 Enterprise edition and a Model database. On a virtual machine I have installed SQL Server 2012 Standard Edition and want to create a copy of the Model database on it.

I have read about the differences between the editions and it seems that no Enterprise-specific features are used in the Model database (anyway, I need to test the migration to be sure).

Which is the better way to move the database from the Enterprise to the Standard edition:

  • creating full backup and restoring it
  • scripting the database as .sql file and executing it
marc_s
  • 9,052
  • 6
  • 46
  • 52
gotqn
  • 4,348
  • 11
  • 52
  • 91

0 Answers0