Dumping postgreSQL database to SQL Server database

Dumping postgreSQL database to SQL Server database

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

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

Postby vseethini » Tue 06 Jan 2009 14:18

Thank you for the suggestion.
vseethini
 
Posts: 4
Joined: Fri 02 Jan 2009 09:37

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

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

Move PostgreSQL to SQL Server 2005

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

Postby Shalex » Fri 20 Mar 2009 14:29

We support Import and Export Data Wizard only in BIS 2008 at the moment.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL