Edit

Share via

Step 2: Create a SQL database for pyodbc Python development

  • Article

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.
  • 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.

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