attach northwind DB to SQL Server 2012

[marlan]

Hi,

I'm trying to improve my SQL Server skills, and got stuck in the beginning...
I have SQL Server 2012 & VS 2013 installed, and downloaded Northwind and Pubs sample DBs.
I can't get the sample DB's attached to the server, these are 2000 versions...
Any way around this?
A link to a newer version?
Some way to convert the files?
Maybe an Access version I can import into a new DB I can create?

TIA

 

[SQL_Hell]

Download the new northwind, which is called Adventure works:

https://msdn.microsoft.com/en-us/library/aa992075.aspx

 

[Rx_]

Trying to improve SQL Server Skills:
Let me recommend this:
http://www.access-programmers.co.uk/forums/showthread.php?t=270202&highlight=migration
It is all free.
SQL Server Migration Wizard for Access (SSMA)
Plus SQL Server Native Client (used for ODBC and is standard for Microsoft AZURE)

If you have the time, set up a free AZURE (SQL Server on the Cloud) account.
Pay attention to the long encrypted Link and password that will be used in the ODBC statement to create a Linked Table using SQL Server Native Client.
These would be great skills to have, it enables multiple Access Front End in different locations to link to a cloud SQL Server DB (AZURE). I think the first GB is free, don't quote me on the size.

AZURE is like SQL Server except, it adds a TOP x to limit bandwidth.
So, either write the filters to limit the return records, or create a loop to pull data in a group at a time.
In theory, you could create a front-end with linked tables to AZURE, post the front end on this forum, and people could connect to your AZURE DB.
If you have time, it might be a fun project to post and take bragging rights about.