The last 10 lines just before Use Master will also need to be removed for the script to execute successfully. To run in Azure, take the SQL script from line 63 onwards as the database already exists. To set up this sample in Azure create a new Azure SQL DB and then run the script directly from inside the Azure portal query editor. This database was originally shipped along with Northwind and it features a set of books and stores in a relational database. Size: 11 tables 23 authors, 43 employees, 18 titles Theme: Bookshops with Autouths, books, publishers and stores The database itself is a similar complexity to Adventure Works however rather than being focused on people, businesses and contacts it focuses on the more traditional orders and products. The only edit needed to make to the script in Azure is to remove the initial few lines down to SET DATEFORMAT mdy As these create the database which has already been done. You can easily run the SQL setup script directly from the Azure portal from the query editor. Despite its age this database still works with Azure and can now be downloaded as a SQL script from github under the MIT licence. Northwind Traders is the oldest of these samples and originally shipped with MS access and Excel 97, later being added to SQL Server 2000. Size: 13 tables, 91 customer records and 9 employee records Theme: Imports and exports specialty foods from around the world 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. 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. 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. Size: Light Version - 12 tables, 847 customers, 295 products (27mb)Ĭreated many years ago (maybe 2005) the Adventure Works database is often the go-to sample. Theme: Multinational manufacturing company called Adventure Works Cycles 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. While the content may still be relevant there is a high chance things may have changed and the content may no longer be accurate.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |