SQLTeam.com | Weblogs | Forums

How to restore database in sql server adventuredatabase sample of 2012 in 2008r2?

sql2012
sql2008r2

#1

how to restore database in sql server adventuredatabase sample of 2012 in 2008r2 ?
I want to practice on sql server and i have only sql server 2008 on my machine.


#2

you can't restore a SQL Server 2012 database on a SQL 2008R2.

Why not just download the 2008R2 edition of the sample db ?


#3

You can never do this because MS SQL architecture does not allow this, Means you can move or forward the data from older version of database to newer version. So, you can only upgrade the database from 2005 to 2008 or 2008 to 2012 version but you can’t downgrade the database.

Only one solution is that, you can manually create the T-SQL script using TSQL Script and Data Generator Wizard in SQL Server 2012 rebuilds the database in SQL Server 2008R2.
Databases that you want to address, you can use SQL Server Integration Services to automate the script generation.