Hi Jeff The 'magic bullet' is usually to resize all your type 1 files to type 19 before trying the migration. Regular file names (not directory) will be truncated using a sequence number but that's not an issue - they will go across correctly. Type 1 files won't. Any SQL tables will also cause problems - you usually have to end up wiping the SICA pointer from the file header.
Also a side note - when accidentally restoring type 1 files once I came across a file named CON. That's a reserved file name in Windows, but it still created the file - and objected heavily when it tried to access it again. I was stuck with it, since Windows also refused to delete it. Same for any other reserved file names - not usually a problem but it was the end of one of these mangled file paths (something like ACCOUNT.RE/CON). Also of course remember that AIX is case sensitive but Windows isn't.. So if you have equivalent items in a directory file in different case they will overwrite. Again not usual, but worth writing a ten line program just to check these across your directory files. And if you use globally cataloged programs, remember to backup and restore catdir as well... I wrote a utility that packages up an account for restoring on another platform, with options like changing file paths, restoring the indices, resizing and including/excluding Q files and remote files in the package. If you get stuck using the uvBackup route, drop me an email. Brian > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jef Lee > Sent: 27 January 2009 05:31 > To: u2-users@listserver.u2ug.org > Cc: Steven Tilden; John Steer; Glenn Summerfield; Glenn Cameron > Subject: [U2] Moving a UniVerse a/c from Unix to Windows > > Does anyone have the magic bullet? We have a UniVerse account > that was backed up using uvbackup on an AIX platform. We > restored the account on to a Windows platform and the sky fell in. > > Firstly there was the 13 (14?) character naming boundary. > File names & record names that were longer than this boundary > were broken in the Unix system into "acceptable" chunks. I > think this protocol dates back decades (centuries?<chuckle>). > Well so far with much fiddling and leg work we have gotten > passed that. > > Now the indices on files are failing to maintain their > integrity. This is what happens: > 1. Look for a record using a keyed search and it was not > found 2. Rebuild the indices using BUILD.INDEX 3. Repeat #1 > and the record was found 4. Add or edit a record affecting a > keyed field and the indices return to #1. > > What's the answer? Do we need to change the way we physically > port the account? Is there a tool that will resolve the > problem? Should we create a new empty account and copy all > the records into it, then build the indices? > > All thoughts and guidance appreciated. > > Our UniVerse is: > >CT VOC RELLEVEL > > RELLEVEL > 0001 X > 0002 10.1.11 > 0003 PICK > 0004 PICK.FORMAT > 0005 10.1.11 > > > > Thanks, > > Jeffrey Lee > Senior Analyst/Programmer > > IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, > Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie > Road, Applecross, WA, 6153 > P: (08) 9315 7000 F: (08) 9315 7088 > W: http://www.itvision.com.au > ___________________________________________________________ > > NOTICE : This e-mail and any attachments are intended for the > addressee(s) only and may contain confidential or privileged > material. Any unauthorised review, use, alteration, > disclosure or distribution of this e-mail (including any > attachments) by an unintended recipient is prohibited. If you > are not the intended recipient please contact the sender as > soon as possible by return e-mail and then delete both messages. > ___________________________________________________________ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
