PostgreSQL to MS SQL Server RRS feed

  • Question

  • Hi,
    I have a requirement to dump all tables in a postgreSQL database to a SQL Server 2008 database. The postgreSQL database has more than 600 tables. I want to use SSIS(will automatically convert postgreSQL types to SQL Server data types easily and create tables ) for this but it will take lot of time since the numbers of tables is huge. I tried to use SQL Server Import wizard with various postgreSQL providers but the option  "copy data from one or more tables" is disabled or threw errors.  Are there any tools which would solve my problem ?

    Thank you
    Wednesday, January 7, 2009 10:23 AM