Check out SAVE.RESTORE.AT, which is freeware that I published recently
on my site (http://Nebula-RnD.com/freeware). It allows you to
save/restore entire accounts between any MV systems through AccuTerm.
That completely eliminates the tape issue. I just did a R83/D3
migration and this will help for R83/jBase as well.
I’ll be happy to answer questions about the freeware but it would help
if requests for in-depth assistance were framed in a services
engagement. If you wish, I will be happy to manage the data migration
aspect of your client’s effort, and you can assist with the details of
code conversion, etc.
I'll be happy to provide more info here or via email about how the
utility works.
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET worldwide
and provides related development services
Remove.pleaseNebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms/about
Yes, that’s how it works. One site has been using it for nightly R83 backups until we can get them migrated to D3. It’s a heck of a lot better than trying to do it by floppy.
T
Remember, jBASE v5 is a 64bit implementation.
Doug
Douglas Lee Owens
Ashwood Computer, Inc.
10671 Techwoods Circle
Cincinnati, OH 45242
Office (513) 563-2800
Cell (513) 312-0341
Dave – I updated the sparse documentation with information that responds to your points below. I will be happy to work with you (or anyone) to ensure the utility can be understood for productive usage.
http://Nebula-RnD..com/freeware/SRAT_README.txt
(Look for “28-Feb-2012 Update”)
I did not fill in the jBase-specific bits of code myself (I’ve only used it for D3 so far) so I’m particularly interested in helping anyone who wants to get this fully working for jBase – and then of course I’d like to roll all changes back into the freeware source package!
Regards,
T
From: David Grenfell
Tony: Thanks for this.
I am assuming that both R83 and Jb must be up and running at the same time to use this. I just installed jb and r83 on to the same box so obviously can only run one at a time. I will however, be obtaining jb 4.x shortly, so will put it on another box and Accuterm also. I will keep you informed of progress.
Dave
> From: Tony
> Dave, good to see you here.
>
> Check out SAVE.RESTORE.AT, which is freeware that I published recently
> on my site (http://Nebula-RnD.com/freeware). It allows you to
> save/restore entire accounts between any MV systems through AccuTerm.
> That completely eliminates the tape issue. I just did a R83/D3
> migration and this will help for R83/jBase as well.
>
> I’ll be happy to answer questions about the freeware but it would help
> if requests for in-depth assistance were framed in a services
> engagement. If you wish, I will be happy to manage the data migration
> aspect of your client’s effort, and you can assist with the details of
> code conversion, etc.
>
> I'll be happy to provide more info here or via email about how the
> utility works.
>
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
> Nebula R&D sells mv.NET worldwide
> and provides related development services
> Remove.pleaseNebula-RnD.com/blog
> Visit http://PickWiki.com! Contribute!
> http://Twitter.com/TonyGravagno
Almost there! The Saved files are pulled from AccuTerm into your XP. So when the save is complete, you have a directory with a bunch of files on your PC. If nothing else you now have a good backup of R83 and it’s time to take a vacation!
When you’re ready, open a connection into jBase, check the code, compile, create an account, etc. Then run the program to Restore into jBase. You’ll be prompted for the path to the saved files which are on your XP. You’ll probably need to do this a couple times to get a feel for the process. Be sure you don’t accidentally blow away any changes you make to the MIGRATION.BP programs.
Each process is asynchronous, you do the save, stop, restore, stop. For reference however, you can do multiple saves and restores simultaneously with different AccuTerm sessions – you just wouldn’t be saving and restore the same account at the same time. Hope that makes sense (and that someone else here gets something out of this J ).
When you get back, feel free to email me direct and we can setup a call to discuss it a little more – I’ll spend some personal time with you to work through some of this. But like I said, the code is free and open source, but if we’re going to spend any “real” time with it then it would be nice to put an hour on the clock. (Your client has gotten away without paying for their system for a Long time, it’s not unreasonable to ask them to pay something for a migration.)
HTH
T
(Enjoy the vacation!)
�
As an aside,�I put R83 on an old Pentium 233 box, and it worked perfectly.� I then installed windows 2000 on the other half of the hard drive,�and now seems the only way I can boot PICK�is to use the floppy to execute the monitor.� I guess the multiple boot thing doesn't work because windows doesn't recognize the pick partition as valid.
Partition Commander is the only product outside of our industry that I know of which recognizes the name Pick in its configuration. With that you can multi-boot back and forth.
For this non-jBase phase of your effort I recommend posting to the MVDBMS forum or even the TigerLogic forum. Once you have the data extracted using MIGRATION.BP you might want to come back here and share notes about jBase-specific requirements. Call it as you wish.
Good luck!
Nebula R&D sells mv.NET and other Pick/MultiValue products
Worldwide, and provides related development services
--
To unsubscribe, send email to jBASE-unsubscribe@googlegroups.com
Congrats on progress so far.
It would have been nice for the MVDBMS group to have benefit from the non-jBase aspects of this effort. Oh well.
well guys, I have my two boxes side by side with R83 running on a Pentium 233, and my newer xp/pro/jbase box running beside it. Both are connected with a serial cable and I am able to log on to R83 using "Netterm". Next step is to get familiar with "Accuterm". So far, so good.
Mike - he doesn’t have serial ports and you think he’d have a USB port? J
A serial port is just a ISA/PCI card, easy to find in most junk shops these days for a couple bucks. I have a box full of them.
From there Dave needs a properly pinned serial cable so that he can reach out from one PC with AccuTerm into the R83 box. Dave, you might need a cross-over adapter for this to swap pins 2/3. And of course you need to work through whether you’re using a 25pin or 9pin serial adapter on both ends. Oh boy, get out those crimpers and the magnifying glasses… (Better you than me, bud. ;) )
Another alternative (and much faster though more costly) is to put a NIC in the R83 box and then negotiate a one-time / week-long license with EasyCo for PicLan (http://piclan.com/). Then you can telnet into R83 and the world becomes a much better place – for this week anyway.
Another option that I have never tried – load R83 into a virtual machine (free VMware Player). You might then be able to somehow connect “virtually” through the serial port, or use PicLan as above. The good news here is – No Hardware! The bad news – you may be on your own in trying to get this to work and there are no guarantees that it will. You’ll need to look around the VMware forums for anyone trying to make use of virtual serial ports.
Completely off-topic for this thread and for jBase, but regarding multiboot with Windows and Linux:
You _can_ install Linux first, then Windows. But you need to go back and re-install GRUB (or other) to the MBR as the bootloader afterward so that you can get a selection when you boot. As mentioned earlier, I’ve been using Partition Commander for more versatility (and I have something like 8 partitions that I can boot from on one of my boxes). YMMV
HTH
T
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
Tiny Bear's Wild Bird Store
"Everything For The Backyard Bird Enthusiast, Except For The
Birds"
Info, Forum: http://www.TinyBearMarketing.com
Store: http://Stores.TinyBearMarketing.com
Toll Free: 1-855-TinyBear (855-846-9232)
Scripting the OS-provided FTP command is always “iffy”. I highly recommend downloading cURL, and making it a part of your lifelong toolkit. It allows for all kinds of transfers, it’s well supported, very stable, very popular, cross-platform, and is easily scripted from MV.
Here are a couple examples that were posted to CDP (RIP) some years ago:
https://groups.google.com/d/msg/comp.databases.pick/rrU9W1TsN5E/soRBQiwTPNcJ
https://groups.google.com/d/msg/comp.databases.pick/mQm9tcRh1v8/6DJglzGo-DMJ
I have a great deal of code based on cURL for use with client projects … not for publication in a forum, sorry.
HTH
T
--
From: David Grenfell
>Tony:
>Couple of questions to make sure I'm on the right tack here.
>Do I create the MIGRATION.BP both in R83 and in jBase?
Yes. And the R83 side is already done for you. Note also that the R83 code is broken into a number of includes to keep it below the 32k item size limit, but for jBase you can use the one-item program.
>When I run the "save" while logged in R83, is the saved info stored on the XP box ?
Yes, it’s pulled from AccuTerm and stored in a directory local to your client PC where AccuTerm is running. The idea is that you would open a session into jBase as soon as a R83 save is complete, and then push that data, back through Accuterm, and out into new jBase files.
>I haven't used ACCUTERM before, so I might be silent for a couple of days while I try to figure it out.
IMO, it’s the best MV emulator available.
Quick primer:
You have a layout which is a container for sessions.
Then you have sessions which represent individual connections.
A layout is like a web browser, and sessions are like tabs on the browser which point to individual websites.
So you can open one session to R83, another to jBase, and then save them as a single layout. Open the layout again and your connections are instantly re-established.
Once you have a connection there are many features allowing for data movement between sessions or to/from the PC running a session. There are also GUI features and others which are irrelevant for this exercise. AccuTerm does not include non-MV features like AnzioWin or others, but all of the same functionality is possible using scripting. (I’m not using scripting in the migration code, just file transfers.)
I just got off the phone with a colleague and we were going over their GUI options. For a simple GUI effort, there are around 4 options in AccuTerm for varying degrees of quality. All of those can be done by a BASIC programmer. From there the next step is to consider other technologies and products, so there are Lots of options for cost, time, and skills when someone says “I need a new GUI”. For our purposes, the point here is that AccuTerm is much more than a simple terminal emulator, so you may want to consider using it for a variety of purposes. Feel free to email with questions.
>I have your SAVE.RESTORE programs T-DUMPED to a floppy, so am ready to put them to good use.
Wish this was just a simple conversion from R83 to jbase, but my jbase version has a lot of new code (25 years of updates and modifications), and also a lot file structure changes too that I will have to compensate for.
Source code will come over from program files. Make sure you have backups in jBase, and look at the code to see how it decides whether to over-write existing files. Rather than trying to pull data into an application account that has been prepared for application processing. I recommend creating a new account in jBase, pulling all data over, and then working with the results. This separates tasks, with data migration being one, and application upgrade being another.
>Thanks again for help thus far. I am doing a detailed documentation of what I am doing, so I can forward to you when finished.
>Dave.
Now THAT is great news, thanks. Your docs and code updates will be posted for others. Please don’t hesitate to email with basic questions – or to ask your client if we can put something more significant on the clock. ☺
T
I believe the issue is that in R83 there are the multiple items broken up into Include items. So try this:
BASIC MIGRATION.BP XBASIC <<< that should compile with no issues
CATALOG MIGRATION.BP XBASIC
SSELECT MIGRATION.BP = “SAVE]”
XBASIC
File =MIGRATION.BP
Item.Name = <<enter>>
Precompile Y
Compile NO … you don’t want to compile Include items.
When that’s done, BASIC MIGRATION.BP SAVE.RESTORE.AT.
That will pull in the Includes.
HTH
T
I believe the issue is that in R83 there are the multiple items broken up into Include items. So try this:
BASIC MIGRATION.BP XBASIC <<< that should compile with no issues
There are issues with this compile.
says line 159 is a bad statement. Looking at the code I see "...OKAY = TRUE"
Then several more error messages such as LINE 158 "ELSE" CLAUSE MISSING
There are also a couple of Blank lines , that R83 CANNOT HANDLE. On one of my instances of trying to correct, I removed these two blank lines.
Perhaps this is a version for another mvdb system.
Dave
Tony wrote:
> > BASIC MIGRATION.BP XBASIC <<< that should compile with no issues
> There are issues with this compile.
> says line 159 is a bad statement. Looking at the code I see
"...OKAY = TRUE"
Those three dots are tabs that must have got into the code when I did
a Format or transfer between OS’s.
Just replace the tabs with spaces. (Position on the K, hit delete
several times, fill in the O).
> Then several more error messages such as LINE 158 "ELSE" CLAUSE
MISSING
Yup, I missed that. On line 160, from the READ ITEM block, change END
to END ELSE NULL.
> There are also a couple of Blank lines , that R83 CANNOT HANDLE.
> On one of my instances of trying to correct, I removed these two
blank lines.
Yup, missed those too, probably in later re-formatting.
When you're done here we should send Kevin King a revised version of
XBASIC.
Please feel free to email me notes like this so that we don’t bore our
colleagues. When you have a working version of the package for jBase
I’m sure people will be more interested in details.
Good luck,
T
Does anyone know the name of the tool for migrating jBASE to ORACLE?
Regards,
Tunji
If you are looking for a permanent migration, then you will probably
need to write something custom to export in a format that you can then
bulk upload into Oracle (I'm no expert in this area)
Hope this helps
Simon
=======================================
Simon Verona
Director
Dealer Management Services Ltd
T: 0845 686 2300
========================================
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-unsubscribe@googlegroups.com
It is a permanent migration of data from jBASE to ORACLE in a T24 environment after upgrade.
Tunji AGBAJE
Sent from my iPad
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to jB...@googlegroups.com
> To unsubscribe, send email to jBASE-un...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
Partition Commander is the only product outside of our industry that I know of which recognizes the name Pick in its configuration. With that you can multi-boot back and forth.
For this non-jBase phase of your effort I recommend posting to the MVDBMS forum or even the TigerLogic forum. Once you have the data extracted using MIGRATION.BP you might want to come back here and share notes about jBase-specific requirements. Call it as you wish.
Good luck!
Nebula R&D sells mv.NET and other Pick/MultiValue products
Worldwide, and provides related development services
Remove.pleaseNebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
From: David Grenfell
I'm back, all browned up and ready to begin. Hit my first snag. The computer I was going to use for xp/jbase has no serial ports, so will have to look for either an older box, or a serial port card. When I get this put together, I will begin the transfer process.
As an aside, I put R83 on an old Pentium 233 box, and it worked perfectly. I then installed windows 2000 on the other half of the hard drive, and now seems the only way I can boot PICK is to use the floppy to execute the monitor. I guess the multiple boot thing doesn't work because windows doesn't recognize the pick partition as valid.
I will post progress reports.
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
Correction... T-dump is the way for _Dave_ to go. Respectfully, he had many issues in using the freeware which had nothing to do with that software itself, though in fairness he helped to improve the code and packaging as well. Someone else would have a different experience and therefore their conclusions may be different.
Dave is correct that moving data across the wire can take a long time. For this reason it's fault-tolerant and can continued in the save and restore wherever it left off. It was intended to be used in an environment where it was otherwise impossible to get a save, not in an environment where the time to get a save was inconvenient. Dave has been lucky to have options that others may not have.
T-Dump is viable if you have a floppy drive and time to sit there with floppies. I wrote the freeware for a site that required over 100 floppies for a single save, and after days of trying they couldn't get a single good restore. I've seen that scenario play out many times. For some sites the hardware is so crippled that the floppy drive isn't even active. With the software solution, the save/restore process can also be done remotely, not an option with floppies.
It's unfortunate that Dave was unable to use the software successfully, but that experience should not be used as a guide for someone else who is facing a similar challenge.
I still welcome a contribution to the SAVE.RESTORE.AT FOSS utility for moving data to and from jBase. I'll be happy to provide the latest version and guidance to anyone interested. It would be nice for the utility to be ready for a jBase user whenever they need it, rather than struggling with customizations when they're attending to other emergencies.
Visit http://PickWiki.com! Contribute!
From: Charlie Noah
Thanks for the update. It looks like T-DUMP is the way to go. I haven't had a chance to play with it any more since we last corresponded. I'll probably get #1 son to bring my old AP machine downstairs from my old office, since I can't climb the stairs very well anymore. Sure glad I bought an external floppy for my XP machine.
--