Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

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​