Steps: Installing the Northwind and Pubs Databases So, this article illustrates how to install Northwind and Pubs using graphical tools and methods. Personally, I favor using graphical (GUI) tools and methods over typing cryptic commands and deciphering error messages. The download attached to this article contains the SQL Server 2000 versions of these files. Perhaps there's an easier way: this article. This does not support users in installing these important samples into SQL Server. Microsoft provides the queries for installing, but not the *.mdf and *.ldf files for the databases themselves. However, hats off to Microsoft for putting apples with apples. It goes part-way, creating a Program Files\Microsoft Visual Studio 8\SDK\Samples\Setup directory containing, e.g., instnwnd.sql, a query script that ostensibly can be used to install the Northwind sample database. NET 2005 Standard Edition installation does not distribute these databases. It's worth noting, for example, that a default Visual Studio. I see this article as illustrating just another way to accomplish a similar objective. There undoubtedly will be readers who will protest and say that I should use *.sql query files whenever possible this is good and a perfectly acceptable practice. However, I am focused on usability, and not on making things harder than they have to be. There are probably several good reasons for this. 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. ![]() It's lost on me why one must use *.sql query scripts to install these samples. So, enjoy this article, for what it's worth. 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 2005, 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. I am an experienced technical writer, and an astrophysicist. Therefore, back then I wrote this article, so as to help other SQL Server beginners. However, I was unable to find anything in MSDN that actually walked one through installing them in SQL Server Management Studio. I was searching the documentation and came upon samples making use of the Northwind and the Pubs databases. I wrote this back in 2005, when I myself was just starting out with SQL Server. SQL Server beginners and database development beginners are the audience for whom this article is written. This article is to help you get started quickly with SQL Server samples, so as to use them to learn basic techniques. Being a SQL/SQL Server newbie myself, I figured there may be others in my boat who might want both databases in an easily-accessible spot, and an easier, less error-prone way of installing them into SQL Server 2005 Express Edition than, say, running SQL query scripts. They are used in countless tutorials and walkthroughs published by Microsoft and others. The Northwind and Pubs sample databases are staples of other sample code on this and other development websites.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |