![]() To navigate around you should download the AdventureWorks OLTP Database Diagram for Visio: ![]() The file size is small, but there are many tables inside this database. Extended data warehouse (DW_Ext): with a lot more data (883 MB).Lightweight (LT): with a smaller set of data (7 MB).You can download a backup of the database for your version of SQL Server as part of the SQL Server Samples Repository. Thanks to the liberal license ( MIT license), you are allowed to use this database for whatever you like. With nearly 20.000 customers, over 70.000 orders and 500 products there is enough data for your examples. That stopped a few releases ago, but the database still does exist. ![]() Microsoft created a long time ago the fictitious multinational manufacturing company called Adventure Works and shipped the AdventureWorks database as part of SQL Server. They would work with any table, as long as there is just enough test data. However, most examples do not require handcrafted tables. The more time I spend with the setup, the less time I have to write the blog posts. ![]() Whenever I want to explain something that requires a database, I have to spend a lot of time to create the tables and test data before I even can start with the part I want to show.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |