Northwind sample database for MySql, PostgresQL etc.
This project is inspired by Microsoft Sample Databases, but it only targets other databases, such as MySql, PostgresQL, etc.
This folder contains scripts to create and load the Northwind sample databases.
If you are looking for the script of MS Sql Server, please check out the repository from their github.
This project is created to create a sample CRM-like demo database in a few seconds with tiny test data.
The sample databases in the project are customized. Some tables' and columns' names have been changed on purpose.
mysql -u user_id -p northwind < northwind.sql
sudo su - postgres
psql -d postgres -U postgres -f northwind.sql
# Launch mongodb in Linux
systemctl start mongod
sh mongo_import.sh
echo "db.getCollectionNames()" > getColNames.js
mongo mongodb://localhost/northwind < getColNames.js
# You may see some output as follow:
# .......
# ......
# MongoDB server version: x.x.x
# [
# "category",
# "customer",
# "employee",
# "employeeTerritory",
# "orderDetail",
# "product",
# "region",
# "salesOrder",
# "shipper",
# "supplier",
# "territory"
# ]
cd db-samples/sqlite3
sqlite3 northwind.db < northwind_core.sql
sqlite3 northwind.db
>.tables