Step 2: Create a SQL database for pyodbc 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.
    • .
• pyodbc 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

Step 3: Proof of concept connecting to SQL using pyodbc