Dumping postgreSQL database to SQL Server database

vseethini · Post by **vseethini** » Fri 02 Jan 2009 10:48

Hi,
I have to dump postgreSQL database to SQL Server 2008 database. I'm looking at various options like SQL Server Import wizard, SSIS ..of doing this. The postgreSQL database has more than 600 tables. Can you suggest other ways of accomplishing doing this job ?

Thanks,
RK

AndreyR · Post by **AndreyR** » Tue 06 Jan 2009 14:09

Import and Export Wizard (which is a part of SSIS) is the most appropriate way for described dumping.

vseethini · Post by **vseethini** » Tue 06 Jan 2009 14:18

Thank you for the suggestion.

vseethini · Post by **vseethini** » Wed 07 Jan 2009 09:14

But using SQL Server Import wizard, the option "copy data from one or more tables" is disabled. Since I have hundreds of tables, it would be very hard to type SQL select query for each table.
Is there any other way to do this ?

Thanks,
RK[/b]

AndreyR · Post by **AndreyR** » Thu 08 Jan 2009 09:12

We are working on this issue. I will let you know as soon as the results will be available.

aserobian · Post by **aserobian** » Fri 20 Mar 2009 13:50

I am evaluating dotConnect and was wondering if any updates on this issue?

How can I move PostgreSQL database to SQL Server 2005?

Shalex · Post by **Shalex** » Fri 20 Mar 2009 14:29

We support Import and Export Data Wizard only in BIS 2008 at the moment.

Devart Forums

Dumping postgreSQL database to SQL Server database

Dumping postgreSQL database to SQL Server database

Move PostgreSQL to SQL Server 2005