microsoft / microsoft/sql-server-samples

Simple way to load Contoso sample data into an Azure SQL DB

Open
#842 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Description

I simply would like to have the Contoso sample data in an Azure SQL database. There's a possibility to load AdventureWorks sample data when creating an Azure SQL database, but not the Contoso sample data. I'm far from an DBA, and need simple instructions. I can see there are instructions to load the Contoso database into Azure Synaps as well as using Polybase, but this is far more complicated than just choosing the AdventureWord as sample data when you create a database.

And I guess the same process could also be used to load the two versions of WorldWildImporters as well

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reviewing the existing AdventureWorks sample-database creation flow and the current Contoso instructions for Azure Synapse and PolyBase. Define a simpler Azure SQL Database loading path, including whether it can also support the two World Wide Importers versions, and document the steps so a non-DBA can complete them.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
cloud, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.