Archive. Posts from 2004 to 2016, kept as they were written. My current blog is at dariuszparys.com.

One of the things when setting up an demo environment (a fresh install) is to integrate the Northwind sample database on the demo environment. I normally just use a SQL Server Express for demos and I take Northwind to have data to play with, what else. I know there is some discussion around Northwind, but I for myself know that anyone in the audience knows Northwind, so no need to explain 15 valueable minutes on a more complex Schema.

So a blank SQL Server Express install on my machine is taking me to the following steps:

  1. Download the Northwind sample database from download.microsoft.com
  2. Run the Setup with the default settings. On my box the installed directory is "c:\SQL Server 2000 Sample Databases"
  3. Open a Command Prompt
  4. Change to the script directory, in my case cd "c:\sql server 2000 sample databases"
  5. Execute the following command: sqlcmd -S (local)\sqlexpress -E -i instnwnd.sql(assuming that your SQL Server Express is installed with default settings which is the named instance SQLEXPRESS)

That's it. Northwind is now installed on SQL Server Express.