See https://github.com/jpwhite3/northwind-SQLite3

"All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Also included are two versions prepopulated with data - a small version and a large version"

Answer from peak on Stack Overflow
🌐
GitHub
github.com › jpwhite3 › northwind-SQLite3
GitHub - jpwhite3/northwind-SQLite3: SQLite3 version of Microsoft's Northwind Database · GitHub
This is a version of the Microsoft Access 2000 Northwind sample database, re-engineered for SQLite3.
Starred by 610 users
Forked by 231 users
Languages   Python 88.7% | Makefile 11.3%
🌐
Wikiversity
en.wikiversity.org › wiki › Database_Examples › Northwind › SQLite
Database Examples/Northwind/SQLite - Wikiversity
March 21, 2025 - -- sqlite3 Northwind.db -- Copy and paste the SQL below into the terminal window to populate the Northwind database.
Top answer
1 of 2
10

See https://github.com/jpwhite3/northwind-SQLite3

"All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Also included are two versions prepopulated with data - a small version and a large version"

2 of 2
3

You can download a version of sqlite3 database from

https://code.google.com/archive/p/northwindextended/downloads

Advantage: It is available immediately. Click and use.

If it's simply to get a sample database for general testing, then just use what's immediately available. If you require an exact copy to match testing results (for instance), then download and convert MS data yourself to ensure exactness since the file's header indicates modifications and added foreign keys and contains no other certification of content. You really need to answer this for yourself based on your own requirements.

Without knowing anything about the conversion process, I would at least guess that the date values are not precisely the same since sqlite has no native DateTime type, rather such values would have needed to be converted to string values and/or Julian numeric values. Of course the values themselves may represent the same dates and times, but processing of query data would certainly require special handling. BLOB values for images should also produce the same images, but retrieving and using those values will likely be different than getting them from other databases. I suppose there could be other data values/types that different handling would apply since sqlite really has no distinct, strict numeric types, rather just type affinities.

🌐
Kaggle
kaggle.com › code › munawarsaudagar › create-a-sqlite-northwind-database
Create A SQLite Northwind Database | Kaggle
November 5, 2024 - Explore and run AI code with Kaggle Notebooks | Using data from No attached data sources
🌐
DevExpress
docs.devexpress.com › product information › northwind sample database
Sample Northwind SQLite Database (nwind.db) | .NET Reporting Tools | DevExpress Documentation
February 6, 2025 - <configuration> <connectionStrings> <add name="nwind" connectionString="XpoProvider=SQLite;Data Source=.\Data\nwind.db" /> </connectionStrings> </configuration> The Northwind Access 97 database is the legacy database used previously in the Reporting examples.
🌐
GitHub
github.com › jpwhite3 › northwind-SQLite3 › blob › main › dist › northwind.db
northwind-SQLite3/dist/northwind.db at main · jpwhite3/northwind-SQLite3
SQLite3 version of Microsoft's Northwind Database. Contribute to jpwhite3/northwind-SQLite3 development by creating an account on GitHub.
Author   jpwhite3
🌐
Tdmdal
tdmdal.github.io › mma-sql › SQL_Intro_Sqlite.html
SQL_Intro_Sqlite
We start by setting up a connection to our sample database, Northwind DB. ... # load the SQL magic extension # https://github.com/catherinedevlin/ipython-sql # this extension allows us to connect to DBs and issue SQL command %load_ext sql # now we can use the magic extension to connect to our SQLite DB # use %sql to write an inline SQL command # use %%sql to write SQL commands in a cell %sql sqlite:///northwind.sqlite3
🌐
O'Reilly
oreilly.com › library › view › c-7-1-and › 9781788398077 › 48d0291c-4aa3-4a1a-b1fd-888967487125.xhtml
Creating the Northwind sample database for SQLite - C# 7.1 and .NET Core 2.0 - Modern Cross-Platform Development - Third Edition [Book]
November 30, 2017 - Enter commands to change to the Code folder, change to the directory named Chapter11, and run the SQLite script to create the Northwind.db database, as shown in the following commands:
Authors   Mark J. PriceDustin Heffron
Published   2017
Pages   800
Find elsewhere
🌐
Kaggle
kaggle.com › datasets › munawarsaudagar › northwind-2000-sqlite
Northwind 2000 SQLite | Kaggle
November 5, 2024 - Discover what actually works in AI. Join millions of builders, researchers, and labs evaluating agents, models, and frontier technology through crowdsourced benchmarks, competitions, and hackathons.
🌐
GitHub
github.com › matthewblott › northwind-sqlite › blob › master › dist › northwind.db
northwind-sqlite/dist/northwind.db at master · matthewblott/northwind-sqlite
SQLite version of Microsoft's Northwind Database. Contribute to matthewblott/northwind-sqlite development by creating an account on GitHub.
Author   matthewblott
🌐
SQL Online AiDE
sqliteonline.com
SQL Online IDE - Fast SQL Editor | SQL Compiler
SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics
🌐
Swift Package Index
swiftpackageindex.com › Northwind-swift › NorthwindSQLite.swift › 1.2.4 › documentation › northwind › northwind
Northwind Documentation – Swift Package Index
[object Module] · Last updated on 7 Apr 2024 · The Swift Package Index is entirely funded by sponsorship. Thank you to all our sponsors for their generosity
🌐
NodePit
nodepit.com › db sql - prepare the northwind database with sqlite and h2
DB SQL - Prepare the Northwind database with SQLite and H2 — NodePit
These tables are included in the local database knime://knime.workflow/../data/Northwind_small.h2 (they all have a unique ID […]
🌐
Librerías Gandhi
gandhi.com.mx › sqlite-for-data-analysis-and-visualization-with-python-gui › p
SQLITE FOR DATA ANALYSIS AND VISUALIZATION WITH PYTHON GUI - Librerías Gandhi | Librería online en México
1381936SQLITE FOR DATA ANALYSIS ... database which is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades....
🌐
Medium
dancruzmx.medium.com › aprende-sql-2da-parte-el-motor-sqlite-6507626a43ba
Aprende SQL 2da parte, el motor SQLite | by Daniel Cruz | Medium
May 30, 2022 - sqlite> .open northwind.db sqlite> .read northwind_ddl.sql sqlite> .tables sqlite> .read northwind_dml.sql sqlite> .dbinfo
🌐
Embarcadero
docwiki.embarcadero.com › RADStudio › Alexandria › en › Demo_Databases_(FireDAC)
Demo Databases (FireDAC) - RAD Studio
FireDAC uses the Northwind as a demo database. The SQLite and MS Access demo databases are preinstalled and do not require any additional configuration. For other DBMS, you have to set up the connection and create a database. FireDAC contains SQL scripts, CSV data files, and BAT files.
🌐
NodePit
nodepit.com › prepare the northwind database
Prepare the Northwind Database — NodePit
December 29, 2021 - These tables are included in the local database knime://knime.workflow/../data/Northwind_small.h2 (they all have a unique ID " id") shipper product customerdemographic employee customercustomerdemo supplier orders category region employeeterritory customer orderdetail territory one VIEW with a combination of informations productdetails_v URL: northwind-SQLite3/Northwind_small.sqlite https://github.com/jpwhite3/northwind-SQLite3/blob/master/Northwind_small.sqlite URL: SQL H2 - more examples https://hub.knime.com/search?tag=H2&type=Workflow
🌐
Amazon
amazon.com › SQLITE-DATA-ANALYSIS-VISUALIZATION-PYTHON › dp › B0B4J8144X
SQLITE FOR DATA ANALYSIS AND VISUALIZATION WITH PYTHON GUI: Siahaan, Vivian, Sianipar, Rismon Hasiholan: 9798838490193: Amazon.com: Books
In this project, you will use SQLite version of Northwind database which is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The Northwind database contains the sales data for a fictitious company ...
🌐
Amazon
amazon.com › SQLITE-DATA-ANALYSIS-VISUALIZATION-PYTHON-ebook › dp › B0B594PLQH
SQLITE FOR DATA ANALYSIS AND VISUALIZATION WITH PYTHON GUI 1, Siahaan, Vivian, Sianipar, Rismon Hasiholan, eBook - Amazon.com
In this project, you will use SQLite version of Northwind database which is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The Northwind database contains the sales data for a fictitious company ...
🌐
Netcore
northwind.netcore.io
Northwind Web Services
The entire datasource for the Northwind project is contained in this Northwind.sqlite database created by this unit test.