Dataexp / Dataimp utilities

Repository:
--------------
As per my understanding, Siebel repository resides in around 148 tables.For better access,there is also a binary form of repository called SRF,compiled and stored on all siebel servers.

1.Seed data
2.Repository Data
3.User Data

Siebel database utilities
----------------------------
Dataexp/Dataimp utilities :
As per my understanding, This utility is very nice for importing data from one db to other.but this utility has not been documented anywhere.So before doing any migration, take proper backup.It needs to be used on siebel instruction only.But It works very well all time.No matter what is source database and what is destination data base.you can import data base from production to local, local to prod .Before import, Truncate table that removes all old records and sync with new.
Close thick client and tool as well.
Cmd syntax:
C:\Program Files\Siebel\8.0\Tools\BIN\Dataexp /U USERNAME /P PASSWORD /C "ODBC NAME" /D SIEBEL TABLE OWNER /F C:\export.dat /L c:\log.txt
It imports table by table and continuously prompt for table name.
Same for import.