Adventureworks in SQL 2012

After trying different RCs, finally this weekend I got time to download SQL 2012 rtm dev edition from my dreamspark account. And my first decision was to get some test dbs with some nice data. And choice was pretty simple, use Adventureworks sample databases from CodePlex. But with a bit of surprise, they don’t have installer yet. You have option to download different sample databases based on you requirement … but no installer is created like we found in previous editions !!

So once you download your database from site, you will need to manually copy that MDF file to any where you want to have you database and then attach it to instance of 2012. Just use below command it you are good,

CREATE DATABASE AdventureWorks2012 ON 
(FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG 
GO

That’s it for now.

It’s Just A Thought … Peace

Gaurang Sign

Leave a Reply

Your email address will not be published. Required fields are marked *