SQL Server

Use the SQL Server replication guide when you need to read tables or queries from SQL Server and write the results to MotherDuck. The guide covers Python, pyodbc, SQL Server authentication, and loading dataframe results into MotherDuck.

How it works with MotherDuck

1. Connect to SQL Server with the Microsoft ODBC driver and pyodbc.
2. Read a SQL Server table or query result into a dataframe.
3. Connect to MotherDuck from Python and persist the dataframe as a MotherDuck table.

Related content

• Replicating SQL Server tables to MotherDuck
• Loading data into MotherDuck
• MotherDuck authentication