Tony,

  If you don't have any Allbase tools such as LeeTech's DBAdvisor/SQL
or Bradmarks Flexibase/SQL, then you can go into ISQL and do an
"UNLOAD TO INTERNAL" on the source, copy the resulting file, then
do a corresponding "LOAD FROM INTERNAL" on the receiving end.  That
assumes the structures are identical.  If not, then you can use a
"UNLOAD TO EXTERNAL"/"LOAD FROM EXTERNAL" and specify the structures
of the flat files.
  This method is fine for relatively small amounts of data, but for
large amounts of data, it can take a while.  Although I haven't tried
it, I believe SuprTool can also be used against Allbase as well as
Image (although that may be an extra-cost option).

Regards,
Michael L Gueterman
Easy Does It Technologies
Allaire Alliance Partner
email: [log in to unmask]
http://www.editcorp.com
voice: (888) 858-EDIT -or- (509) 943-5108
fax:   (509) 946-1170
--

> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> Behalf Of Tony Furnivall
> Sent: Tuesday, October 20, 1998 10:51 AM
> To: [log in to unmask]
> Subject: [HP3000-L] Moving data from one (Allbase) database to another
> Importance: High
>
>
> I'm looking for some help!
>
> Is there any easy way of transferring a whole load of data
> from one Allbase
> DBE (in a test account) to another DBE (jn a production account)? The
> production DBE already exists, but is essentially empty. IOW it can be
> re-created. However, I believe that Allbase only deals with
> fully qualified
> filenames, and as a result will not willingly allow me to do
> a simple (eg)
> Restore.
>
> Any ideas, comments suggestions?
>
> Tony
>