Skip to content Skip to sidebar Skip to footer

Update Mssql Table Through Sqlalchemy Using Dataframes

I'm trying to replace some old MSSQL stored procedures with python, in an attempt to take some of the heavy calculations off of the sql server. The part of the procedure I'm having

Solution 1:

As the pandas doc suggests here :

from sqlalchemy import create_engine 
engine = create_engine("mssql+pyodbc://user:password@DSN", echo = False)
dataframe.to_sql('tablename', engine , if_exists = 'replace')

engine parameter for msSql is basically the connection string check it here

if_exist parameter is a but tricky since 'replace' actually drops the table first and then recreates it and then inserts all data at once.

by setting the echo attribute to True it shows all background logs and sql's.

Post a Comment for "Update Mssql Table Through Sqlalchemy Using Dataframes"