Jeremy, Amy, All
PgUpT was a 'fun??' project I worked on when I was evaluating Postgres.
Basically the tool 'upsizes' a microsoft Access 97 database by automatically
creating a load of SQL and plpgsql files which both recreate the database
and should reproduce all of the referential integrity held within the Access
db.
It produces:
functions to enforce all integrity
datafiles in a format easy to import into Postgres
triggers to attach the functions to table modifications
shell scripts to load all of the data and create the database
ftp scripts to transfer all of the files from M$ to Linux/Unix
Its been tested with 6.5 and seems to work ok although I haven't touched it
for a while.
There are a couple of outstanding bugs:
1. Recursive Joins
2. Multiple joins between 2 tables.
There are fairly easy workarounds to both 1 and 2 ;-)
The web address is http://dspace.dial.pipex.com/boylesa/pgupt/pgupt.shtml.
Hope its of Use/Interest.
Steve
-----Original Message-----
From: jeremy@xxedgexx.com <jeremy@xxedgexx.com>
To: amy cheng <amycq@hotmail.com>
Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>;
yd80@dial.pipex.com <yd80@dial.pipex.com>
Date: 17 August 1999 12:46
Subject: Re: [GENERAL] what is PgUpT ?
>
>wrong.
>
>-jeremy
>
>> hi, Stephen Boyle or any other experts,
>>
>> I saw the email in the archive of this list on foreign keys/triggers,
>> seems that the triggers are created by a tool "PgUpT", what is
>> that? where I can get it?
>>
>> amy
>>
>> thanks!!!
>>
>> #############################below are excerpt from archive
>> ......
>>
>> -------------------------------------------------------------------------
---
>> ----
>> -- File: create_functions.sql
>> -- Description: Create functions on the database.
>> -------------------------------------------------------------------------
---
>> ----
>> drop function fn_CompaniesProjects_XUXM1();
>>
>> create function fn_CompaniesProjects_XUXM1() returns opaque as '
>> --
>> -- REFERENTIAL INTEGRITY CHECKING CODE BETWEEN Companies AND Projects
>> -- ENSURES THAT INTEGRITY IS MAINTAINED AFTER AN UPDATE ON TABLE
Companies
>> (Master)
>> -- Generated by PgUpT 17/07/1999
>> --
>> DECLARE
>> l_Flag integer;
>> BEGIN
>> l_Flag := 0;
>> ..........................
>> ########################################end
>>
>>
>> _______________________________________________________________
>> Get Free Email and Do More On The Web. Visit http://www.msn.com
>>
>
>
>http://www.xxedgexx.com | jeremy@xxedgexx.com
>---------------------------------------------
>Y2K. We're all gonna die.
>