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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy