Saturday, September 05, 2009

Where to download Northwind database?

I am working with Llblgen recently. The sample code requires the SQL2000 Northwind database. It took me some time to locate it. Let share the link then:

Download Northwind database samples

The sample installs the samples on 'C:\SQL Server 2000 Sample Databases' folder.

How about just download Northwind sql script?
Here you go . Rename the file to instnwnd.sql after download.

Is the script compatible with other version of SQL server (SQL2005, SQL2008) ?
Yes. Use the instnwnd.sql. Execute the sql script in your SQL Management Studio. The script create the Northwind database schemas with sample data. At least database backup (mdf and ldf) compatibility is least of your problem.

I didn't try the mdf backup restore but did create the db in SQL2008 instance using just sql script. No problem at all.

Happy trying. :)

No comments: