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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 11:33 AM
Points: 3,647, Visits: 8,161
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.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 11:33 AM
Points: 3,647, Visits: 8,161
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.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

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