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

title	Step 2 - Create an SQL database for pyodbc
description	Step 2 of this getting started guide involves creating a database in SQL Server or Azure SQL Database for this pyodbc sample.
author	David-Engel
ms.author	v-davidengel
ms.date	08/22/2023
ms.service	sql
ms.subservice	connectivity
ms.topic	how-to

Step 2: Create an SQL database for pyodbc Python development

Create an 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 an 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 an 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 pyodbc