Page 1 of 1
Dumping postgreSQL database to SQL Server database
Posted: Fri 02 Jan 2009 10:48
by vseethini
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
Posted: Tue 06 Jan 2009 14:09
by AndreyR
Import and Export Wizard (which is a part of SSIS) is the most appropriate way for described dumping.
Posted: Tue 06 Jan 2009 14:18
by vseethini
Thank you for the suggestion.
Posted: Wed 07 Jan 2009 09:14
by vseethini
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]
Posted: Thu 08 Jan 2009 09:12
by AndreyR
We are working on this issue. I will let you know as soon as the results will be available.
Move PostgreSQL to SQL Server 2005
Posted: Fri 20 Mar 2009 13:50
by aserobian
I am evaluating dotConnect and was wondering if any updates on this issue?
How can I move PostgreSQL database to SQL Server 2005?
Posted: Fri 20 Mar 2009 14:29
by Shalex
We support Import and Export Data Wizard only in BIS 2008 at the moment.