September 18, 2012 at 11:26 am
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 🙂
September 18, 2012 at 11:37 am
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
September 20, 2012 at 9:58 am
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 🙂
September 20, 2012 at 11:01 am
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 :-P) 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".
September 22, 2012 at 5:04 pm
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 :-P) 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
. 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 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply