I am trying to use the Import/Export Wizard to import all the tables and table data from a PostgreSQL database into dynamically created tables in my SQL 2005 database. I have done this many times in SQL 2000 by selecting the PostgreSQL data source from the drop-down list in the wizard. However, in SQL 2005 this data source is not available.
Yes, I did make sure the driver is installed, and I even created a saved Data Source and a linked server to the PostgreSQL database just to make sure there were no fundamental problems. I also tried using the .NET odbc driver, but it does not give me the very important "Copy data from one or more tables or views" option... which is essential since I am dealing with hundreds of tables.
Any help is appreciated.
Import Wizard using a PosgreSQL Source
JDT
Unfortunately, there is no simple way to do this. You already found the .NET provider for ODBC but that transfer is restricted to a single table as you noticed. You could build the package programmatically, but I am not sure if you would go that far.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
If still available, you may want to try with the DTS 2000 wizard and connect to SQL 2005 server as the destination.
dcallan