You can spend many nights playing with these parameters, and obtain different databases that can produce trends and exceptions you can analyze for your demos. The transactions generated in the Sales table are not entirely random: there are parameters used to control the distribution of transactions over products, customers, stores, and time. You can customize all these files and produce any content you want. We added stores and customers using other files obtained by random data generation services. The content of the database is based on the Microsoft Contoso sample database. You must be a C# developer to partake in this game.
#Sample data generator sql server 2012 code
Customize the C# code of the tool to implement new features. There is a Visual Studio solution with a C# project running in. You must alter configuration files and the PowerShell scripts. When you create a new database in Azure SQL Database, you can create a blank database, restore from a backup or select sample data to populate your new database. Produce your own Contoso database. Download the executable, customize the parameters, and run the scripts to control the content of the database in terms of volume and data distribution. To get sample data for Azure SQL Managed Instance instead, see restore World Wide Importers to SQL Managed Instance. Just download from the latest release: Contoso databases with different sizes are already available for download. Download an existing, ready-to-use Contoso database. You get a backup that you can restore on a SQL Server or Azure SQL instance. You can use the content available in different ways: You can customize the database generated in size and data distribution, developing your version of the Contoso database. 
Contoso Data Generator is a free open source tool to generate sample Contoso databases on SQL Server based on a star schema.
0 kommentar(er)
