Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Northwind Database for SQL Server 2005 Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 11:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 4:35 PM
Points: 57, Visits: 107
Hello to all. This is my first post in this forum so I guess I am a "Grasshopper" again. I don't mind being a "Grasshopper" if I can just learn to use SQL Server 2005.
I just yesterday managed to make a connection to the SQL Server with some very fine assistance by a few MS MVP's (In another Forum) but the ADO.NET 2.0, Microsoft Press, author Rebecca M. Riordan uses the Northwind and the Pubs databases in the exercises throughout the book so I need to add these two databases to the Server so that I can continue my study of this very fine text. I have the Northwind Database in my Microsoft Access but I do not want to try to create such a hugh database in the SQL Server on my own. I have created two of the Tables to the Pubs DB and it was quite a bit of work and subject to my errors. MS furnishes text so that I can build these two databases in my SQL Server but that is a hugh task for this newbie. Any suggestions on how or where I can download the databases and add them to the Server? Thank you and have a good day. JRichards54
Post #1360915
Posted Tuesday, September 18, 2012 11:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:40 PM
Points: 2,786, Visits: 5,968
Have you tried to google them?
The first result when I searched Northwind was https://www.microsoft.com/en-us/download/details.aspx?id=23654
It might be different for you since I'm using DuckDuckGo



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1360920
Posted Thursday, September 20, 2012 9:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 4:35 PM
Points: 57, Visits: 107
Luis Cazares (9/18/2012)
Have you tried to google them?
The first result when I searched Northwind was https://www.microsoft.com/en-us/download/details.aspx?id=23654
It might be different for you since I'm using DuckDuckGo


Mil gracias, senor Cazares.
I printed "Northwind Database Installation" and "Installing the Northwind Sample Database", both from Microsoft webpages. I just noticed that the latter is for VS 2012 and I need to go back and click on "Other Versions" to get specific instructions on how to install to SQL Server 2005 Developer Edition.
But I have spent over 2 weeks getting a connection to my Server and it has the Adventureworks DB available and the MS Book (Microsoft SQL
Server 2005 Implementation and Maintenance) that I am studying uses that DB in their exercises. Right now I want to continue my studies in this text and I will get back to installing the Northwind DB when I am ready to study "Microsoft ADO.NET 2.0".
BTW, I am not fluent in Spanish. I know about 9000 words but I do not converse well, everyone (even 6 year old children) know more Spanish than I do. He estudiado mucho pero aprendido un poco. Thanks again. JRichards54
Post #1362110
Posted Thursday, September 20, 2012 11:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:40 PM
Points: 2,786, Visits: 5,968
The instructions are mostly generic as VS 2012 is independent of SQL Server.
You can follow the instructions here: http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa if you don't feel confident to use the SQL Script files (.sql).
I hope you have less problems than the ones you had installing SQL Server.
I wonder how did you know that I'm a native spanish speaker (maybe my accent ) as there's no information of that on my profile. BTW, 9000 words is a great vocabulary for someone who "has learned just a few".



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1362168
Posted Saturday, September 22, 2012 5:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 4:35 PM
Points: 57, Visits: 107
Luis Cazares (9/20/2012)
The instructions are mostly generic as VS 2012 is independent of SQL Server.
You can follow the instructions here: http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa if you don't feel confident to use the SQL Script files (.sql).
I hope you have less problems than the ones you had installing SQL Server.
I wonder how did you know that I'm a native spanish speaker (maybe my accent ) as there's no information of that on my profile. BTW, 9000 words is a great vocabulary for someone who "has learned just a few".


Sir, I knew by your name being posted at the very top after [quote]. Also, you included a couple of lines at the bottom that were in Spanish.

Yes, I certainly have had more success installing the Northwind and pubs databases. I ran the SQL Script files (.sql) from my VS 2005 Query Editor and when I clicked on "Execute" there it was. I then ran it again for the other one and both are now in my Server along with the Adventureworks and the System Databases (which I do not mess with).

Thank you for the help and the comments. Have a good day. JRichards54
Post #1363179
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse