Export Siebel Repository from Local database.

Today morning I came to know that our database was refreshed and we did not exported repository from server. I felt like all our efforts wiped out which we put on Siebel patching activity and crash resolution from last month. But after spending some time I thought we can use repository export from local data base.I did small test which worked fine and I was able to get most of the configuration since I had synchronized (full get) local database copy few days before refresh. I thought to share details with you.

I created batch file with below details.

ExportReposity_Local.bat

 

Set SIEBEL_HOME=D:\SIEBEL\TOOLS

REM example USER=BDHOBALE

Set USER=<localDBG_User>  

REM example PASSWORD=BDHOBALE 

Set PASSWORD=<localDBG_Password> 

Set LNG=enu 

-- use odbc connection used For local tool 

Set ODBC="SSD Local Db Default instance" 

%SIEBEL_HOME%\BIN\repimexp /a E /g %LNG% /u %USER% /p %PASSWORD% /c %ODBC% /D SIEBEL /M y /R "Siebel Repository" /F customer.dat /L exprep.log 

For repimexp parameter detail click here

Once you execute above batch file, you will see below window with progress.

Finally end result.

You can use repeximp to import exported file into local database but you need pass different parameters.