Thread: Import Data from MS SQL Server

Hi..
      Im Daniel and need soem help in importing data from MS SQL Server
to Postgresql DB. Is there a bulit in option for importing from
Postgresql? Help me out!!

Regards,
Daniel.

> Hi..
>       Im Daniel and need soem help in importing data from MS
> SQL Server to Postgresql DB. Is there a bulit in option for
> importing from Postgresql? Help me out!!

You can easily use the DTS tool in SQL Server to export data to
PostgreSQL through the ODBC driver.

//Magnus

You can use the DTS of SQL Server and there use the ODBC driver for PostgreSQL for making a connection to the target PostgreSQL database.

/Shoaib

Daniel wrote:
> Hi..
>       Im Daniel and need soem help in importing data from MS SQL Server
> to Postgresql DB. Is there a bulit in option for importing from
> Postgresql? Help me out!!
>
> Regards,
> Daniel.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
Hi Daniel,
PG Lightning Admin has some very nice import export/abilities and can
import directly using the MS SQL ADO drivers that are already on your PC.
Currently we only create structure automatically for Access tables, and
this is only because no one has asked for MS SQL server structure creation.

Basically you would just create a empty table with the fields you need,
open the empty table, select import, select ADO, then follow the wizard.
The wizard will allow you to map the source fields to your fields.

You can also do everything else you need to do right from PGLA, no need
for anything else.

Check it out here:  http://www.amsoftwaredesign.com/lightning_admin.php

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

On 7 Jun 2006 05:13:15 -0700, Daniel <DFelix19@gmail.com> wrote:
>
> Hi..
>       Im Daniel and need soem help in importing data from MS SQL Server
> to Postgresql DB. Is there a bulit in option for importing from
> Postgresql? Help me out!!

as others suggest, you definately want to go 'dts' on anything to/from
ms sql server.  dts can actually transfer from any odbc to any other
odbc source.  you could for example do a dts transformation from ms
sql to csv files and then do csv import into postgresql via the copy
command.  you would still want to use dts to create the tables though.
 one tip: take the opportunity during the conversion process to
convert your tables to all lower case and no spaces in the
table/column names.

Merlin