
Microsoft has made available an example database called AdventureWorks that is intended for testing and demonstrating different Microsoft SQL Server functionalities.
You can download the sample from Microsoft’s website or Github.
HTML report / online ER Diagram#
The Database Diagram was created by loading the database structure from locally installed AdventureWorks sample. The target database was SQL Server 2022.
How to use the ER diagram/HTML report: click on a db table in the online ER Diagram. A new window opens – and in the window you can view the details of the table, including how indexes are defined and other details of the selected SQL Server database table.
In this ER diagram you can see tables grouped and aligned to subject areas, for example Person, Production, Purchasing, Sales and DBO etc.
Details#
- Target database
- SQL Server
- Luna Modeler project file
https://www.dbdiagrams.com/online-diagrams/adventureworks.dmm- AdventureWorks license
- MIT License
Build on AdventureWorks#
Improve the system
Extend AdventureWorks
Planning a plugin, module or extension? Find the tables you will work with, then model your own tables and amendments right next to them, before you write a line of code.
Get inspired
Craft a new system
Building something of your own? Study how AdventureWorks structures its data, take the ideas that work, and design a data model that fits your project.
Respect the license. AdventureWorks is released under the MIT License. This permissive license lets you reuse and adapt the work, as long as you keep the original copyright and license notice. Whatever you build, read the license and follow its terms.