0

I am trying to export a DB from SQL Server to PostgreSQL. The simplest way seems using the export tool in SSMS as I have read here .

But I get the following error:

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch

which means components mismatch between x64 and x86.

My SQL Server 2019 is 64 bit, PostgreSQL is version 15 64 bit, and the ODBC driver that comes with StackBuilder on installation is 64 bit too as seen here:

[]

The destination configuration in SSMS is the following:

[]

I have installed additional x64 ODBC driver from here but with the same result.

I can't understand what I'm doing wrong and why I have architecture mismatch, thank you.

Improve this question
4
  • 1
    Are you using the 32bit or 64bit import wizard? Commented Jun 27, 2023 at 12:33
  • Right click->task->export data, I don't know the wizard version. Commented Jun 27, 2023 at 12:39
  • 1
    Sounds like you are using the 32bit wizard from SSMS/SSDT; that won't support the 64bit driver. If you want/need to use the 64bit driver, you need to (install and) launch the 64bit import/export wizard which only comes packaged with the SQL Server installer. Commented Jun 27, 2023 at 12:46
  • I have downloaded the 32 bit version of ODBC driver so now it has platform 64/32 bit and now it works. Thanks! Commented Jun 27, 2023 at 12:54
Related questions
3327
How to add a column with a default value to an existing table in SQL Server?
1801
How can I delete using INNER JOIN with SQL Server?
1698
How can I do an UPDATE statement with JOIN in SQL Server?
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.