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 >