Skip to content

Latest commit

 

History

History
45 lines (31 loc) · 1.76 KB

step-2-create-a-sql-database-for-pymssql-python-development.md

File metadata and controls

45 lines (31 loc) · 1.76 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Step 2 - Create a SQL database for pymssql
Step 2 of this getting started guide involves creating a database in SQL Server or Azure SQL Database for this pymssql sample.
David-Engel
davidengel
08/22/2023
sql
connectivity
how-to

Step 2: Create a SQL database for pymssql Python development

Create a SQL database using either Azure SQL or SQL Server.

Prerequisites

  • Python 3
    • If you don't already have Python, install the Python runtime and Python Package Index (PyPI) package manager from python.org.
    • Prefer to not use your own environment? Open as a devcontainer using GitHub Codespaces.
      • Open in GitHub Codespaces.
  • pymssql package from PyPI.

Create a SQL database

The samples in this next section only work with the AdventureWorks schema, on either Microsoft SQL Server or Azure SQL Database.

Azure SQL Database

Create a SQL database in minutes using the Azure portal

Microsoft SQL Server

Microsoft SQL Server Samples on GitHub

Important

Don't forget to get the credentials for the database you create.

Next steps

[!div class="nextstepaction"] Step 3: Proof of concept connecting to SQL using pymssql