Thread: 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. Anyway, thanks for your help. John
> -----Original Message----- > From: John Wells [mailto:jb@sourceillustrated.com] > Sent: 17 January 2003 14:38 > To: pgadmin-support@postgresql.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.
You're right. I'm at work currently, and I forgot the bastards up in the Ivory Tower of Firewalls and Security-through-Obscurity started blocking our cvs access around a month ago. Sorry about that...I'll get it tonight. Thanks Dave. John Dave Page said: > I don't see any reason for the > timeouts though unless there is a problem with your ISP, or between > ours.
Dave, Hello again. Is SP5 a requirement for this vb project? I'm trying to load it in a base VB6 install and getting errors from the forms like: '0' could not be loaded Line 0: The file C:\windows\Desktop\pg\pgadmin2\frmConnect.frm could not be loaded. Any ideas? Thanks! John
<sigh> sorry for the wasted bandwidth. Checked em out with linux cvs and was bitten by the CR-LF bug. Thanks, John
Hm....loaded VS Service pack 5 and it's still doing it. Any suggestions? Thanks! John John Wells said: > Dave, > > Hello again. > > Is SP5 a requirement for this vb project? I'm trying to load it in a > base VB6 install and getting errors from the forms like: > > '0' could not be loaded > Line 0: The file C:\windows\Desktop\pg\pgadmin2\frmConnect.frm could not > be loaded. > > > Any ideas? > > Thanks! > > John