3

I am trying to export data from PostgreSQL to MSSQL Server.

Currently, I am exploring the SQL Server Import and Export Wizard.

I have installed the native postgres driver and got the .Net Data Provider for PostgreSQL. Everything seemed fine until I tried to use it.

I got the following: Cannot get the supported data types from the database connection

postgre native driver problems

Is this a driver problem or am I missing something?

Update:

Like @Panagiotis Kanavos suggested I have installed OLEDB driver

There seems to be a problem with it.

I fill the required data, Test the connection, it says that it is successfully established, but when I click Next to continue with the Wizard I get:

===================================

Cannot get string literals from the database connection "Provider=PostgreSQL OLE DB Provider;User ID=postgres;Data Source=localhost;Location=MyDb;Extended Properties=". (SQL Server Import and Export Wizard)

===================================

Object reference not set to an instance of an object. (DTSWizard)

Here are some screenshots:

enter image description here

After clicking Next:

enter image description here

There isn't any useful information about this problem. If anyone has any idea?

iliyan tanev
  • 377
  • 2
  • 15
  • Maybe. The native driver is *not* the `.NET Data Provider`. Have you tried the OLEDB driver ? Which driver did you install? It would be (a lot) easier to find an answer if you posted the *errors*, not a screenshot of the errors. You can't google screenshots – Panagiotis Kanavos May 15 '17 at 09:28
  • I actually have posted the error. At least the error message. :) About the OLEDB driver, I have installed it. At least I think so. [Is this it](http://pgfoundry.org/projects/oledb/)? See my edit for more information. – iliyan tanev May 15 '17 at 09:49

1 Answers1

0

I was successful using the ODBC drivers (64 bit). 32bit drivers had some memory issues on large tables. See this post: Migrating from PostgreSQL to SQL Server 2008

Derek Wade
  • 697
  • 8
  • 11