Download backup of Northwind database for SQL Server
By FoxLearn 2/14/2025 2:11:49 AM 299
Download Northwind database SQL Server
You can download the instnwnd.sql
script from the provided GitHub repository to create and load the Northwind sample database for SQL Server.
This folder contains scripts to create and load the Northwind and Pubs sample databases.
- Northwind backup: instnwnd.sql
- Sample backup: instpubs.sql
Before using the Northwind database, you must run the downloaded instnwnd.sql script to recreate the database on an instance of SQL Server. This can be done using SQL Server Management Studio (SSMS) or a similar tool.
Download SQL Server Management Studio (SSMS)
Run the scripts in SSMS
Open SSMS and connect to your SQL Server instance.
Create a new database with name Northwind
Next, In the "File" menu, select Open -> File... and choose the instnwnd.sql
script you downloaded.
Click Execute button to run the script and create the Northwind database on your SQL Server.
Run the scripts in SSDT or Visual Studio
Open SSDT or Visual Studio, then Open the SQL Server Object Explorer.
Next, Connect to the target SQL Server, then open the script in a new query window.
Finally, Run the sql script.
- How to Download and Restore Northwind database to SQL Server
- How to set time to 00:00:00 with GETDATE() in SQL
- Restoring MySQL Databases with mysqldump
- How to use Oracle linked server shows all tables
- How to Convert varchar to uniqueidentifier in SQL Server
- How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
- How to use ROW_NUMBER Function in SQL Server
- How to convert varchar to integer in MySQL