northwind database backup-Sql Server 2005 and 2008

Rating:        Based on 3 ratings
Reviewed:  3 reviews
Downloads: 189004
Released: Aug 11, 2011
Updated: Aug 12, 2011 by binoj7
Dev status: Alpha Help Icon

Recommended Download

Example Northwind.bak.zip
example, 525K, uploaded Aug 12, 2011 - 140688 downloads

Other Available Downloads

Source Code Northwind.sql.zip
source code, 285K, uploaded Aug 12, 2011 - 48316 downloads

Release Notes

Northwind.bak.zip - Northwind database backup for Sql Server 2005 and 2008.
Unzip / decompress the file then use the Restore Database option from Sql Server Management Studio 2005 / 2008 to restore the database

Northwind.sql.zip - - Northwind database creation script for Sql Server 2005 and 2008.
Create a database called northwind in your Sql Server then.
Unzip / decompress the file then open the sql file in Sql Server Management Studio 2005 / 2008 and hit F5.
OR
run the below command (sample)
sqlcmd -S Localhost -d Northwind -i D:\Sql\Northwind.sql

Reviews for this release

     
I had to reduce the rating because of the following: When you bring up the code in SSMS, the code is not color coded and there is some problem with the script (background text). When you run it will say there is no stored procedure 'U'. What I really did was to copy this into NotePad and save it with a different name. I called up the saved file in SSMS. Now it works. In SQL Server 2012 another ...
by mysorian on Oct 25, 2013 at 8:48 AM
     
I could not get the backup version to work so I, too, went to the scripted version. Just to clarify: what the couple other reviewers ran into was an encoding problem. The file is UTF16 and both SSMS and sqlcmd balk at that; you have to convert the file to ASCII. The simplest way to do that is with PowerShell: PS> gc .\northwind.sql -Encoding Unicode | sc northwind2.sql
by msorens on Aug 13 at 9:38 PM
     
I agree with @mysorian (from 2013-Oct-25), I had to create the Northwind DB (Create Database Northwind) command...and edit the SQL code in a Text Editor...and save it then copy it inside the SQL Server Mgr . reason: the code was changed as Spaced characters. eg. if "USE Northwind"? then it changed it to "U S E N o r t h w i n d" !!!
by CoderKim0212 on May 30 at 4:29 AM