Re: Import Data from MS SQL Server

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