Skip to content

Releases: sql-bi/Contoso-Data-Generator

Contoso Data Generator

06 Jul 22:23
@SergioMurru SergioMurru
v1.1.0
1d6fdef
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
Contoso Data Generator Latest
Latest

Contoso databases

IMPORTANT The database files are unchanged: they can be downloaded from the release v1.0.0.0

Contoso-Data-Generator source code and executables

The zip contains the full project, including the compiled executables that are ready to run.
You can use this file if you do not have Visual Studio and you want to generate your own Contoso database by customizing the parameters available.

  • Contoso-Data-Generator-exe-1.1.0.zip

Contoso-Data-Generator source code only

The source code of the DataGenerator, the helper scripts, and the CSV data files for the database creation.

  • Contoso-Data-Generator-1.1.0.zip
  • Contoso-Data-Generator-1.1.0.tar.gz

The parameter configurations for databases greater than 10K in the GenerateDatabase.ps1 are commented out.
After the first test with 10K database generation (so you do not have to wait too much), remove the comments from the configuration line for the desired size to be generated.

Changes from the previous version

  • added language setting in TSQL script to fix date format errors
  • improved documentation
  • added parameter SqlServerInstance to QuickRun.ps1 script
Assets 3

Contoso Data Generator

04 Jun 21:10
@SergioMurru SergioMurru
v1.0.0
5536f3e
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
Contoso Data Generator

Contoso databases

Ready-to-use databases that are generated with the parameters configured in the script.
They are available as SQL Server backups or as compressed (zip or 7z) files containing the MDF/LDF files, ready to be directly attached to SQL Server 2019 (or newer versions) without requiring a restore operation.
The suffix corresponds to the scale of rows included in the Sales table: 10K stands for 10,000, 1M for 1,000,000, and so on.
Files larger than 2GB have been split into chunks under 2GB using 7-Zip.

  • Backup files for SQL Server restore:

    • Contoso 10K.bak
    • Contoso 100K.bak
    • Contoso 1M.bak
    • Contoso 10M.bak

  • Zip files containing MDL/LDF files to be attached to a SQL Server instance:

    • DB Contoso 10K.zip
    • DB Contoso 100K.zip
    • DB Contoso 1M.zip
    • DB Contoso 10M.7z
    • DB Contoso 100M.7z (split in 2 files)
    • DB Contoso 1G.7z (split in 9 files)

Contoso-Data-Generator source code and executables

The zip contains the full project, including the compiled executables that are ready to run.
You can use this file if you do not have Visual Studio and you want to generate your own Contoso database by customizing the parameters available.

  • Contoso-Data-Generator-exe-1.0.0.zip

Contoso-Data-Generator source code only

The source code of the DataGenerator, the helper scripts, and the CSV data files for the database creation.

  • Contoso-Data-Generator-1.0.0.zip
  • Contoso-Data-Generator-1.0.0.tar.gz

The parameter configurations for databases greater than 10K in the GenerateDatabase.ps1 are commented out.
After the first test with 10K database generation (so you do not have to wait too much), remove the comments from the configuration line for the desired size to be generated.

Assets 22