Re: Import Data from MS SQL Server - Mailing list pgsql-general

From Tony Caduto
Subject Re: Import Data from MS SQL Server
Date
Msg-id 4486E3FE.7070107@amsoftwaredesign.com
Whole thread Raw
In response to Import Data from MS SQL Server  ("Daniel" <DFelix19@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Action Table of postgresql
Next
From: Tom Lane
Date:
Subject: Re: What are the characteristics of a good user-defined data type?