I've done a number of these. We had a D3/Aix box that I would restore the tapes on. I would then run a program that renamed all of the D3 files as upper case (made things come through cleaner on UD). It pretty much simply selects the file-of-files and does a rename to xxyyz and then back to the original name 'MCU'd.
I had a pseudo floppy setup (with a 512 block-size). I did an account-save to it then used SFU (now free) to copy the file to the UD windows box. I think I also checked that a binary ftp transfer worked. I then created the tape device in UD (making sure to set the 512 block size). Then did an acct-restore. Worked like a charm. We converted approx 50 clients like this. Others haven't had very good luck. Once you get the data into UD note that D3 is not case-sensitive - but UD is. At least by default, I believe it's an option now. That means that all of your primary and foreign keys need to be in the same case. My old boss even tried taking the unix file the D3 save creates and running it through a Unix utility to upper case ALL of the data. We have a lot of "textual" data that didn't really lend itself to this method, YMMV. I have some more complete notes at work that I can post in the morning if you like. hth Colin Alfke Calgary Canada ________________________________ From: David Wolverton If I to a 'file save' from D3 to a 'disk' tape device, then ZIP the file from a Linux Box onto a Windows Box and unZIP it to do 'account restores' on a U2 box... What surprises await me? The issue on a test conversion I need to run is that the tape drive on the Linux box cannot be accessed on a Windows Box, and go figure, I don't have $3k to throw down for a one-time conversion <g> So - I'd like to use the tape 'disk' file to import. But would love any knowledge from those bearing the arrows of being leaders on this process! They have about 2GB of data - likely much smaller ZIPed, so I can get it on a single 'tape file' and 'ftp' it from one machine to the other (while I'm at lunch...). From there, is it 'smooth sailing'? Also, this customer could care less if I dropped them into UniVerse or UniData - I use UniData more, but that's just a preference I can get over if UniVerse makes this substantially easier. TIA for any thoughts - David [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
