You can use the migrate-export and migrate-import utilities
to back up the TEPS database
- migrate-export.bat
- The migrate-export.bat utility backs up the entire
database by writing its contents as insert statements to a flat file
called saveexport.sql located in install_dir\cnps\sqllib.
It can also be used to move the contents of the database from one
database instance to another. You might use this utility to move the
contents of the database from one windows server to another.
- migrate-import.bat
- This utility is used to read the contents of the saveexport
.sql file created in the migrate-export process and insert
them back into the database. This utility can be used to recover the
database. It reads the contents in the install_dir\cnps\sqllib\saveexport.sql and
rebuilds the database tables and contents. You can also use the migrate-import.bat to
move the contents of the database to another windows server running
the database.
- Run migrate-export.bat.
- Copy the saveexport.sql file from the old Tivoli® Enterprise Portal Server to
the new portal server into the install_dir\cnps\sqllib directory.
- Run migrate-import.bat to read and build the
database tables and contents on the new system.