Hi,
Thanks for the reply.
At this point we just want the quickest way to do it, and don't mind it
being unreadable.
So, I switched to the DBExtract and DBLoad - this works fine, until I try
and use the database and I discovered that it is now readonly until I do a
backup! Doesn't this defeat the purpose?! I believe this is true for the
fastload, too.
I then tried to do a backup, but get the error:
dbmcli on portal>backup_start backup1 DATA
ERR
-24927,ERR_TOOLCHK: external backup tool not found
The file c:\program files\sapdb\indep_data\wrk\PORTAL\bsi.env is
missing or unre
adable.
Any ideas how to fix this? I can't find bsi.env in any of my database work
directories.
If I need to do a backup afterwards, can I not just do a backup and restore
instead of extract/load etc.? I did try this, but I got a wierd "sql
error" when I tried the restore.
Would appreciate any help you can give as I seem to be hitting walls
whatever direction I go in!
Thanks,
David
"Bumes, Hans-Georg" <[EMAIL PROTECTED]>@listserv.sap.com on
15/08/2003 04:27:21 AM
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: RE: Quickest way to export and import data
Hi David,
> We have been using DataExtract to save our data and then import it again.
> Unfortunately now that we have gone up to 1 million records
> in a table, it takes 45 mins to do the import!
> I know there are various ways to do this - what is the **quickest** and
most efficient?
> What kind of speed can I expect in this case?
the answer depends on several preconditions and circumstances.
here are the most important ones:
if you like your extracted data in a *readable* format you have to choose
the
*compressed* or *formatted* format. if your tabledefinition doesn't contain
*blob* columns
you can use the *fastload* command to load the data.
http://www.sapdb.org/7.4/htmhelp/ec/d93fb6400d11d3aa27006094b92fad/frameset.htm
*fastload* isn't supported on tables with *blob* columns.
otherwise you can use the **quickest** internal format *pages* to transport
your data
http://www.sapdb.org/7.4/htmhelp/ec/d93fd1400d11d3aa27006094b92fad/frameset.htm
--
Hans-Georg Bumes
SAP DB, SAP Labs Berlin
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
