Post reply

SQL Server 2005 - SMO - connect to db other than SQL Server

  • March 18, 2009 at 9:30 am

    #198096

    I have been trying to import entire database from PostgreSQL into SQL Server 2005 using SSIS.

    One idea that I found on the web is to use SMO. I created Script Task in SSIS and added some code to connect to remote server and pull all objects to my SQL Server but it doesn't work. When I try to connect to that remote server (PostgreSQL) in the VB.net code I get "SetParent failed for Database" which means it refuses to establish proper connection to that remote server/db.

    Is there a proper code for this to work or some other way to accomplish this task?

    Thanks.

  • March 18, 2009 at 9:52 am

    #962047

    In VB.NET you need to download and install the Postgresql ADO.NET provider make sure you are using the correct version because it comes in both x86 and x64.

    http://pgfoundry.org/projects/npgsql/

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply