![]() Each iteration has been updated for the latest versions of SQL Server. The database has evolved since its introduction in 2005. This database should now be ready to work with in Visual Studio.ĪdventureWorks is for SQL Server. You can install both Northwind and Pubs for use in various projects. Click the to expand the database nodes and right-click any table and choose Edit Top 200 rows to see the table's records. The database you just created should appear. Right-click on Databases in the Object Explorer and choose Refresh. The error reads, "Could not find stored procedure 'sp_dboption'." Since we are not using replication, we can ignore this error.ģ. And it is the same error, for a missing stored procedure that is no longer used. ![]() When you are ready, click the Execute button from the SQL Editor toolbar and the scripts will run.īoth Pubs and Northwind scripts with execute completely with one error each. Pubs is over 2000 lines and Northwind is over 9000 lines but they will create the databases in just a few seconds. Take a look and the query to see what it is going to create. Browse to the SQL Server 2000 Sample Databases folder that was created from the downloaded installation file, click on either instpubs.sql or instnwnd.sql, and click Open.Ģ. Login to MS SQL Server Management Studio and from the main menu go to File > Open > File. You can do this in Visual Studio, but I prefer using SQL Server Management Studio.ġ. ![]() To use either of these databases in later versions of SQL Server we need to execute the query script. ![]() You can't use them anyway, unless your database server is SQL 2000. Open the newly created folder and unless you have some reason to keep them delete all the SQL Database files with file extension MDF and LDF. Double-click to install and it will install to a folder named SQL Server 2000 Sample Databases in the root of C:\. That being said, they are still useful for learning database fundamentals partially due to that simplicity.Īfter clicking on the link above, use the Download button to download SQL2000SampleDb.msi. Pubs is a book vendor and Northwind Traders is an import/export company.They are both old and rather simplistic compared to modern databases. Northwind came later as an example database for Microsoft Access and was later ported to SQL 2000. The earliest example database from Microsoft was Pubs, which according to this article came from SYBASE and has been around since the nineties. Also included are download links and some practical installation information. In this article I have listed five that are useful in training and testing. For many years Microsoft has shipped example databases with its database products, SQL Server and MS Access. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |