SQL Server to Python with SQLAlchemy

November 12, 2024  in Python  tagged server / sql / engine / python / connect / sqlalchemy / pyodbc by Mike

---

Do you need to bring data in from a Microsoft SQL Server database into a Python project? This is the code for a Python project I have created in Jupyter Notebook with Anaconda Navigator.

view source

print?

1	import pyodbc

2	from sqlalchemy import create_engine

3	import pandas as pd

view source

print?

1	Server='localhost'

2	Database='MikeTest'

3	Driver='ODBC Driver 17 for SQL Server'

4	Database_Con = f'mssql://@{Server}/{Database}?driver={Driver}'

5

#

6	engine = create_engine(Database_Con)

7	con = engine.connect()

view source

print?

1	TableName = 'Names3'

2	df=pd.read_sql_query(f'SELECT * FROM {TableName}',con)

3

df

Below is the screenshot from SQL Server Management Studio.

Learn with YouTube

How to connect SQLALCHEMY to Microsoft SQL Server Database.

---

---