Generating the initial database data for deployment
Use the Database Schema Tool's
insert
command to generate an SQL script for inserting
system default data into a database.The
insert
command reads the system default
data or serialized class instance data from a specified dump file, then
generates an SQL script that inserts this class data into the appropriate
tables as defined by the persistence mapping.CAUTION: Only
insert data if it does not already exist in the database, otherwise the
insert will fail. If the insert fails because data already existed in the
database, the duplicate data will need to be deleted from the model before
proceeding. To delete data, use the
truncate
command. For
more information about using the truncate
command, see
the NexJ Studio Developer
Guide.To insert data into a database from a dump file: