Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Can I install adventureworks 2012 data in SQL 2008
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 09/27/2013 :  03:07:12  Show Profile  Reply with Quote

I tried doing that and got an incompatibility error. I was wondering if there is a workaround or fix for that or if there is a 2012 DB for SQL 2008R2.

The error message is -
TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'YourComputer'. (Microsoft.SqlServer.Smo)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The database 'AdventureWorks2012' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorks2012'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

For help, click:

Edited by - blastoSO on 09/27/2013 03:08:02

Constraint Violating Yak Guru

352 Posts

Posted - 09/27/2013 :  07:11:40  Show Profile  Reply with Quote
I would doubt that 2012 would work for 2008. MS does not usually do backward for AventureWorks as they have the new bells and whisles in the database.

Is there a reason you are using 2012 instead of 2008R2?

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000