C:\Program Files\Starcounter\StarDump
. sqlite3
files that can be examined or modified with DB Browser for SQLite.C:\Program Files\Starcounter\StarDump
as an environment variable.unload
and reload
, and both of them have their own options.unload
command takes a Starcounter database and creates a sqlite3
file with the data. Running stardump unload
without any options will unload the default
database to %TEMP%\stardump-<database>-<date>.sqlite3
. To specify the unload further, these options can be used:-db
, --database
string
default
-f
, --file
string
%TEMP%\stardump-<database>-<date>.sqlite3
-b
, --buffersize
int
500
INSERT
operation-scp
, --skipcolumnprefixes
string[]
__
-stp
, --skiptableprefixes
string[]
-st
, --skiptables
string[]
-ut
, --unloadtables
string[]
-V
, --verbose
int
2
unloadtables
disables skiptableprefixes
and unloadtables
if they are used together. string[]
values should be space or comma separated.stardump unload --help
to get more information about the available options.reload
command takes a sqlite3
file and reloads it into a Starcounter database. The basic structure of a reload looks like this:--database
and --file
option always have to be specified. reload
command:-db
, --database
string
-f
, --file
string
sqlite3
file to reload-fr
, --forcereload
-offset
, --insertobjectnooffset
long
ObjectNo
offset in the target database-reassign
, --reassignobjectno
ObjectNo
offset to the highestObjectNo
in the target database -noschema
, --skipschema
-noschema, --skipschema
--skipschema
mode, StarDump reloads data of matching tables and columns between existing Starcounter database and reloading dump.-V
, --verbose
int
--verbose
which is set to 2
.--forcereload
is not used, the database should be dropped and created prior to reload to ensure that the database is empty:stardump reload--help
to get more information about the available options.