migrate data from MS SQL to PostgreSQL?

by

I don’t know why nobody has mentioned the simplest and easiest way using robust MS SQL Server Management Studio.

Simply you just need to use the built-in SSIS Import/export feature. You can follow these steps:

  1. Firstly, you need to install the PostgreSQL ODBC Driver for Windows. It’s very important to install the correct version in terms of CPU arch (x86/x64).

  2. Inside Management Studio, Right click on your database: Tasks -> Export Data

  3. Choose SQL Server Native Client as the data source.

  4. Choose .Net Framework Data Provider for ODBC as the destination driver.

  5. Set the Connection String to your database in the following form:

    Driver={PostgreSQL ODBC Driver(UNICODE)};Server=;Port=;Database=;UID=;PWD=

  6. In the next page, you just need to select which tables you want to export. SQL Server will generate a default mapping and you are free to edit it. Probably you`ll encounter some Type Mismatch problems which take some time to solve. For example, if you have a boolean column in SQL Server you should export it as int4.

Microsoft Docs hosts a detailed description of connecting to PostgreSQL through ODBC.

PS: if you want to see your installed ODBC Driver, you need to check it via ODBC Data Source Administrator.

More Related Contents:

  1. How to migrate a PostgreSQL database into a SQLServer one?
  2. SQL Server String or binary data would be truncated
  3. How to get difference of days/months/years (datediff) between two dates?
  4. What is the PostgreSQL equivalent for ISNULL()
  5. What is “with (nolock)” in SQL Server?
  6. Altering a column: null to not null
  7. Best way to store time (hh:mm) in a database
  8. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  9. SELECT INTO a table variable in T-SQL
  10. Is it possible to use user defined aggregates (clr) with window functions (over)?
  11. Random record from a database table (T-SQL)
  12. What does the SQL # symbol mean and how is it used?
  13. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  14. Trigger to fire only if a condition is met in SQL Server
  15. Restore a SQL Server 2000 backup on SQL Server 2012
  16. Cross Domain SQL Server Logins Using Windows Authentication
  17. Random Weighted Choice in T-SQL
  18. SQL select all if parameter is null else return specific item
  19. time format in SQL Server
  20. Python – pyodbc call stored procedure with parameter name
  21. How to execute SSIS package when a file is arrived at folder
  22. Connect to SQL Server through IP address
  23. Why would using a temp table be faster than a nested query?
  24. How to import data from .csv in SQL Server using PowerShell?
  25. Display varbinary Image in Gridview
  26. How to cleanse (prevent SQL injection) dynamic SQL in SQL Server?
  27. Node.js and Microsoft SQL Server
  28. SQL Server 2008 Spatial: find a point in polygon
  29. Does Microsoft OLE DB Provider for SQL Server support TLS 1.2
  30. Implementing one-to-zero-or-one relation in SQL Server

Leave a Comment