
> -----Original Message-----
> From: Joe Shevland [mailto:shevlandj@kpi.com.au]
> Sent: 18 May 2000 09:51
> To: Peter Mount
> Cc: 'Dave Page'; 'pgsql-hackers@postgresql.org'
> Subject: Re: [HACKERS] MSSQL7 & PostgreSQL 7.0
>
> > (as well as ascii text files) to PostgreSQL. I'm open to 
> suggestions if
> > anyone feels there are improvements worth making....
> 
> Firstly I have to say its a great bit of work (pgAdmin), 

Thanks... 

> however it'd be
> nice to see an open source tool mirroring the functionality 
> of the DTS. I
> especially liked the way you could script the mappings 
> between fields, as
> well as the GUI builder for complex transforms (in fact I 
> absolutely loved
> that (when it worked :), I had too long on the beta). As well 
> as being able
> to use pre- and post- conditional actions upon 
> success/failure of certain
> parts, like emailing, calling other programs etc.

Thats an interesting idea. What exactly do you script though? Things like
(pseudo-code of course):

If SOURCETYPE = "AutoNumber" Then
  DESTTYPE = "int4"
  DESTDEFAULT = "nextval('record_id')"  
  EXECSQL "CREATE SEQUENCE record_id"
End If

or have I got the wrong end of the stick completely?

Regards, 
  
Dave. 
  
-- 
"If you stand still, sooner or later something will eat you."
   - James Burke
http://www.vale-housing.co.uk/ (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)  

Thu, 18 May 2000 11:28:52 -0000
Dave Page <dpage@vale-housing.co.uk>
RE: MSSQL7 & PostgreSQL 7.0