Thread: Database Migration Wizard Feature Request

Dave,
    I'm using the Migration Wizard to move a large Access (dare I say)
    database to Pg.  What I see the pg log is a commit on ever row.  Would
    it be possible to add a "batch" type commit.  Say I want to commit ever
    1000 rows.

    Also, during the migration is the second time the tables are selected
    stating to move the data, which would imply one could do a schema only
    migration?

    Great tool!

Tom

> -----Original Message-----
> From: Thomas A. Lowery [mailto:tlowery@stlowery.net]
> Sent: 22 August 2002 13:48
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Database Migration Wizard Feature Request
>
>
> Dave,
>     I'm using the Migration Wizard to move a large Access
> (dare I say)
>     database to Pg.  What I see the pg log is a commit on
> ever row.  Would
>     it be possible to add a "batch" type commit.  Say I
> want to commit ever
>     1000 rows.

Possibly. I doubt I'll have time to look at it though, but if anyone
else wants to submit patches...

>     Also, during the migration is the second time the
> tables are selected
>     stating to move the data, which would imply one could
> do a schema only
>     migration?

Yes. You select the table structure to migrate first, and then whether
or not the data should go as well.

>     Great tool!

Thanks.

Regards, Dave.