The TM setup routine installs several scripts in the <TM_directory>\samples
directories. These scripts can be used to create sample databases to use with
the example transformations in the Samples repository (Samples.mdb).
The scripts supplied are written in SQL dialects appropriate for use with Oracle, Sybase and SQL Server. They are fully commented, so they can be adapted if required for use with other RDBMSs.
There are four scripts for each database type. Two create the source (Books.sql)
and target (Writers.sql) models used in the main examples, and two create the
simpler examples (SimpleBooks.sql and SimpleWriters.sql).
Note that you will need to log in as a user with administrative privileges in
order to run these scripts successfully. Commands near the beginning of each
script involve creating a user, and it may be necessary for you to edit the
scripts to provide extra detail (such as nominating a tablespace to contain the
new model) on the relevant command lines in the files.