Tony, Funny thing about consultants .. first thing they want to do is write a program instead of finding a pre-existing solution.
IF there were a way to move data from one environment to another without charging the client more money just to show off my brilliance that would be the best thing for the client (saving money and getting good results) and myself (why re invent the wheel .. i know i am smart i don't need to prove it to myself again). If there is no such thing then the simple answer would be .. nope .. there is no such thing. No one has ever done it .. set up a 300 baud line and just serialize the data from one box to the next <G> Thanks Saturday, September 13, 2008, 5:06:37 PM, you wrote: >> From: David Tod Sigafoos >> My higher goal is to move data from mvBase to >> uniVerse. Account save / account restore >> What I want is information on if this can be done simply. >> I can, as ray suggested, read the tape OR i can simply >> stream in the file and try to restore on my own. TG> [flame jacket in hand] TG> Moving data isn't a goal, it's a tactical effort to satisfy some TG> more strategic business function. I'm still curious as to why TG> you need to move data using platform-specific media. I find that TG> the real answer to problems we see presented here is frequently TG> that the wrong question is being asked. And while I know there TG> can be some resentment when I question why someone is asking for TG> a specific solution, that line of inquiry frequently leads to TG> saving a lot of time and money in accomplishing the real TG> strategic goal. Seriously, I deal with this all the time. TG> The only valid case I can think of for your inquiry is that you TG> have an old VTF and the source system no longer exists - maybe a TG> crash-n-burn where the user wants to move to U2 rather than to TG> pay for a new mvBASE license. Fair enough. If that's the case TG> then my suggestion is to move the data into a live mvBASE system TG> "somewhere" (which you can get for free from any mvBASE dealer) TG> and then to extract it out using more conventional means. TG> The tape mechanisms in all of these platforms was never intended TG> to be cross-platform. They're intended to backup and restore TG> data to a specific platform. And while we expect to be able to TG> move data from one shop to another, across operating systems, and TG> across DBMS releases, many of us have found there are occasional TG> issues here. Extract data from these proprietary formats is a TG> sure way to win geek points, but it's a pointless business effort TG> considering there are better ways to accomplish the goals. TG> So I would back up a moment (pun intended I guess) and ask why TG> you're not writing flat files that can be transported and then TG> read from the file system? If the systems are local then you can TG> simply write to a file in BASIC that's simultaneously accessed by TG> Universe. I do that for development all the time with a bunch of TG> DBMS's. TG> If the mvBASE system is still up and you want to do this on a TG> regular basis, I'm guessing the environments are remote and you TG> want to duplicate one or more accounts from one platform and just TG> read it somewhere else. All the File-Save process does is to TG> select the SYSTEM file, loop through all MD files, loop through TG> all DICT files, and the copy all the DATA file items in a TG> proprietary tape buffer format. I know you could swing that in a TG> few minutes, using the same type of recursive loop to create TG> directories and write items as files. ( I actually have code TG> like that around here somewhere from an effort where I needed to TG> extract an entire R83 system over a network via AccuTerm. ) TG> Anyway, I hope you accomplish your goals. TG> Best, TG> T TG> Tony Gravagno TG> Nebula Research and Development TG> TG@ remove.pleaseNebula-RnD.com TG> ------- TG> u2-users mailing list TG> u2-users@listserver.u2ug.org TG> To unsubscribe please visit http://listserver.u2ug.org/ TG> __________ Information from ESET NOD32 Antivirus, version of TG> virus signature database 3440 (20080913) __________ TG> The message was checked by ESET NOD32 Antivirus. TG> http://www.eset.com -- DSig ````` David Tod Sigafoos ( O O ) _______oOOo__( )__oOOo_______ "Nearly all men can stand adversity, but if you want to test a man's character, give him power." -- Abraham Lincoln(1809-1865) ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/