Northwind Database · GitHub.Codeplex northwind database download
Looking for:
Codeplex northwind database download |
Subscribe to RSS.Codeplex northwind database download
The Northwind and Pubs sample databases are staples of other sample code on this and other development websites. They are used in countless tutorials and walkthroughs published by Microsoft and others. This article is to help you get started quickly with SQL Server samples, so as to use them to learn basic techniques. SQL Server beginners and database development beginners are the audience for whom this article is written.
I was searching the documentation and came upon samples making use of the Northwind and the Pubs databases. I am an experienced technical writer, and an astrophysicist.
Perhaps it may be the case that Microsoft has already posted new documentation on installing databases into SQL Server Management Studio graphically; however, at the time this article was originally posted back in , at the time I had been unable to locate an equivalent article in the Microsoft documentation; hence, I wrote my own, which has evolved into this article.
It's also lost on me why SQL Server distributions don't come with these databases provided, since they are used so ubiquitously through documentation, websites, and tutorials. There are probably several good reasons for this. However, I am focused on usability, and not on making things harder than they have to be. I see this article as illustrating just another way to accomplish a similar objective. It's worth noting, for example, that a default Visual Studio.
NET Standard Edition installation does not distribute these databases. However, hats off to Microsoft for putting apples with apples. This does not support users in installing these important samples into SQL Server.
Perhaps there's an easier way: this article. The download attached to this article contains the SQL Server versions of these files. Personally, I favor using graphical GUI tools and methods over typing cryptic commands and deciphering error messages.
So, this article illustrates how to install Northwind and Pubs using graphical tools and methods. Step 1 : Using the download link above, download the Zip file containing the following files. Extract the files to a directory on your computer and remember where you put them. For these steps to work, you must have the following files on your computer:. Fill in the appropriate settings on the Connect to Server window that appears, and then click Connect.
Step 3 : Right-click the Databases folder and then click Attach , as shown in Figure 2. Step 4 : In the Attach Databases window, click Add MDF file, and then click OK. The right pane of the Attach Databases window will look as shown in Figure 4. When you're done, and if you did the proper actions, the right pane of the Attach Databases window should look as displayed in Figure 5. Step 8 : To check that everything was successful, in the Object Explorer window, click the plus sign to open the Databases folder.
The Northwind and Pubs databases will be displayed, as shown in Figure 6. Feel free to email me with specific questions about this article, and I will be happy to explain. I also want to invite you to make use of the forums at the bottom of this article. I wish you well and happy programming. Click here for the SQL Server version of this explanation. In this section, I will keep a running history of the changes and updates I've made to this article:.
Figure 4. The right pane of the Attach Databases window after adding the Northwind database. Figure 5. The right pane of the Attach Databases window after adding the Pubs database.
Comments
Post a Comment