Adding the Northwind Data
When first installed, MSDE doesn’t contain any data except the standard set of system tables such as master, model, msdb, and tempdb. Fortunately, the .NET framework includes SQL scripts to install several sample databases:
The Northwind database: instnwnd.sql
The pubs database: instpubs.sql
The IBuySpy portal database: portal.sql
Look for these files in a directory such as C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Samples\Setup. The instnwnd.sql installs the database, tables, and sample rows you need to run all the examples in this book. To install it, you can use the OSQL command-line utility.
Here’s the code required to install the Northwind table to the instance of MSDE that is installed with Visual Studio .NET (assuming the instnwnd.sql file is in the current directory).
osql -E /i instnwnd.sql
Alternatively, you can use SQL authentication with the -U parameter:
osql -U sa /i instnwnd.sql
If MSDE is installed on another computer, or if your computer also has SQL Server installed, you must explicitly identify the MSDE instance you want to use by adding the -S parameter. The following command assumes you are using the version of MSDE installed with Visual Studio .NET:
osql -S serverName\VSdotNET -E /i instnwnd.sql