Theme: Imports and exports specialty foods from around the world Size: 13 tables, 91 customer records and 9 employee records License: MIT Database: External Link Schema: External Link bak format which are not supported by Azure, these must first be imported into a SQL server locally then deployed to Azure using SQL management studio.
Northwind and pubs sample database download#
In addition if you need a larger version of this database it is possible to download and restore one of the backups from the Microsoft docs. When selected this will populate the database with the AdventureWorksLT database ready to use.Ī more detailed guide can be viewed on techielass blog or the official docs. When you select to create a new Azure SQL database under the additional settings tab you can select to use a Sample as the data source. The Adventure works sample is the simplest of the samples to setup and can be done directly inside the Azure portal.
Northwind and pubs sample database full#
The sample data is a moderate size and a full schema is available. The Adventure Work LT database is built into Azure making it a great choice if you just need to get something up and running quickly. Theme: Multinational manufacturing company called Adventure Works Cycles Size: Light Version - 12 tables, 847 customers, 295 products (27mb) License: MIT Schema: External Link Database: External LinkĬreated many years ago (maybe 2005) the Adventure Works database is often the go-to sample. In this post I have reviewed previous sample databases along with a few other options.įor each database I created an Azure SQL database on the basic tier which should be more than enough to import the sample data. Sample datasets are useful for many things, from quick proof of concepts to technical demos, however when you start searching for one to use on Azure it can be hard to know which to choose.
0 kommentar(er)
