Re: Data Migration Wizard and rollbacks

> -----Original Message-----
> From: John Wells [mailto:jb(at)sourceillustrated(dot)com]
> Sent: 17 January 2003 14:38
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Data Migration Wizard and rollbacks
>
>
> I've been using the Database Migration Wizard to port a Sql
> Server database, and it's an awesome tool. It's already
> saved me soooo much time.
>
> Was wondering if there's a way to configure the tool to start
> a new transaction for each table and set of data it's moving.
> The problem is, I'm porting a rather large database over a
> DSL connection, and the connection often drops. I'll be 30
> tables into a migration and my connection will drop, causing
> the entire migration to rollback. It'd be useful if I could
> tell it to just rollback an incomplete table migration,
> rather than the entire db migration.
>
> If no way exists currently, I'd be interested in possibly
> adding the functionality. Trying to download the source out
> of cvs, but it keeps timing out on me.

No, there is no way to do this currently. Please feel free to hack the
code (patches would be appreciated). I don't see any reason for the
timeouts though unless there is a problem with your ISP, or between
ours. Our net connection is running fine right now, and the server
itself is way overpowered for the work it's actually doing.

If you continue to have problems, let me know and I can email you a
tarball.

Regards, Dave.