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. There is a Visual Studio solution with a C# project running in. Customize the C# code of the tool to implement new features.You must alter configuration files and the PowerShell scripts. Download the executable, customize the parameters, and run the scripts to control the content of the database in terms of volume and data distribution. You get a backup that you can restore on a SQL Server or Azure SQL instance.
SAMPLE DATA GENERATOR SQL SERVER 2012 FOR FREE
We have now cleaned up the code and produced minimal documentation to share the tool and make it available for free in an open-source project on GitHub: Contoso Data Generator. We also wanted to be able to control the content so that different trends in the data present for specific countries or stores could be available, thus allowing us to recreate specific situations we wanted to demo in future articles and videos.įor these reasons, our latest investment is a tool we created that is able to generate different versions of the Contoso database used for the course. When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases.
0 kommentar(er)
