pg.ddx.io  pgsql-ports@postgresql.org mailing list archive  
help / color / mirror / Atom feed
M$ SQL server DTS package equivalent in Postgres
3+ messages / 2 participants
[nested] [flat]

* M$ SQL server DTS package equivalent in Postgres
@ 2007-01-23 01:15  Paul Lambert <paul.lambert@autoledgers.com.au>
  0 siblings, 1 reply; 3+ messages in thread

From: Paul Lambert @ 2007-01-23 01:15 UTC (permalink / raw)
  To: pgsql-ports

G'day,

Is there an equivalent in Postgres to the DTS Packages available in M$ 
SQL server.

I use these in SQL server to pre-load data from CSV files prior to 
enabling replication from my primary application. Any pointers on where 
best to go for this would be appreciated. I'm reading about something 
called EMS, is that the way to go?

Sample of one of the files I use:

DEALER_ID^DATE_CHANGED^TIME_CHANGED^BILLING_CODE_ID^DES^BILLING_CODE_TYPE^LABOUR_RATE^LABOUR_SALES_GROUP^CUSTOMER_NO^PARTS_SALES_GRO
f UP^COMEBACK^WORKSHOP^FRANCHISE^LOCATION^DELETEFLAG
F65^23-Jan-2007^10:13^AA^ADVERSITING ADMIN^I^45^40^2196^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^AN^ADV NEW^I^45^40^1636^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^AP^ADV PARTS^I^45^40^1919^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^AS^ADV SERV^I^45^40^2057^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^AU^ADV USED^I^45^40^1775^18^^0^BLANK^0^N
F65^23-Jan-2007^10:13^BA^B R&M ADM^I^45^40^2823^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^BG^BUILDING MAINTENANCE GM 
HOLDEN^I^45^40^1311^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^BN^B R&M NEW^I^45^40^2268^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^BP^B R&M PART^I^45^40^2541^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^BS^B R&M SERV^I^45^40^2680^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^BU^B R&M USED^I^45^40^2401^18^^0^BLANK^0^
F65^23-Jan-2007^10:13^F^FLEET^C^50^27^0^17^^0^BLANK^0^
F65^23-Jan-2007^10:13^FC^FORD COMEBACK MECHANIC^I^65^21^140^19^Y^0^BLANK^0^

Cheers,
Paul.

-- 
Paul Lambert
Database Administrator
AutoLedgers





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: M$ SQL server DTS package equivalent in Postgres
@ 2007-01-23 08:56  Magnus Hagander <magnus@hagander.net>
  parent: Paul Lambert <paul.lambert@autoledgers.com.au>
  0 siblings, 1 reply; 3+ messages in thread

From: Magnus Hagander @ 2007-01-23 08:56 UTC (permalink / raw)
  To: Paul Lambert <paul.lambert@autoledgers.com.au>; +Cc: pgsql-ports

On Tue, Jan 23, 2007 at 10:15:06AM +0900, Paul Lambert wrote:
> G'day,
> 
> Is there an equivalent in Postgres to the DTS Packages available in M$ 
> SQL server.

Nope.

> I use these in SQL server to pre-load data from CSV files prior to 
> enabling replication from my primary application. Any pointers on where 
> best to go for this would be appreciated. I'm reading about something 
> called EMS, is that the way to go?

This you can do using plain COPY commands from psql. You acn script this
as a SQL file. Or you can script using your faviourite scripting
language such as perl or python or whatever. What we don't do is the
advanced transformation features in DTS, but if you're just loading data
it's fully supported.

> Sample of one of the files I use:

<snip>
Looks like a plaitnext file with ^ as field delimiter. See the help for
COPY on how to load that.

//Magnus



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: M$ SQL server DTS package equivalent in Postgres
@ 2007-01-23 22:32  Paul Lambert <paul.lambert@autoledgers.com.au>
  parent: Magnus Hagander <magnus@hagander.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Paul Lambert @ 2007-01-23 22:32 UTC (permalink / raw)
  To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-ports

Magnus Hagander wrote:
> On Tue, Jan 23, 2007 at 10:15:06AM +0900, Paul Lambert wrote:
>> [snip]
> 
> This you can do using plain COPY commands from psql. You acn script this
> as a SQL file. Or you can script using your faviourite scripting
> language such as perl or python or whatever. What we don't do is the
> advanced transformation features in DTS, but if you're just loading data
> it's fully supported.
> 
> 
> <snip>
> Looks like a plaitnext file with ^ as field delimiter. See the help for
> COPY on how to load that.
> 
> //Magnus
> 
> 

Thanks for that, looks exactly like what I wanted.

Appreciate the suggestion.

Regards,
Paul.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-01-23 22:32 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-23 01:15 M$ SQL server DTS package equivalent in Postgres Paul Lambert <paul.lambert@autoledgers.com.au>
2007-01-23 08:56 ` Magnus Hagander <magnus@hagander.net>
2007-01-23 22:32   ` Paul Lambert <paul.lambert@autoledgers.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox