Dumping postgreSQL database to SQL Server database

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
vseethini
Posts: 4
Joined: Fri 02 Jan 2009 09:37

Dumping postgreSQL database to SQL Server database

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 4
Joined: Fri 02 Jan 2009 09:37

Post by vseethini » Tue 06 Jan 2009 14:18

Thank you for the suggestion.

vseethini
Posts: 4
Joined: Fri 02 Jan 2009 09:37

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 1
Joined: Fri 20 Mar 2009 13:43

Move PostgreSQL to SQL Server 2005

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 20 Mar 2009 14:29

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

Post Reply