Sagent : Deployment to Production, Deployment Methods ?

[dipesh73]

Sagenet : Deployment to Production, Deployment Methods ?



We have developed all extraction plans using sagent in our
development environment and now its ready to deploy.

In Development environment we have used
Base View : Base View Name - Stage_BV
Oracle Database - XXDB
USER - stdev

Now for deployment to production, I can copy the repository but want
base view Stage_BV to use Oracle Database - YYDB
USER - stprod

I tried changing this through Sagent Admin and it does, but now if I open Plans from
production repository It still shows table in SQL Batch loader as
STDEV.TABLE_NAME
Even after refreshing the baseview it behaves same and plan fails with error ' Object
STDEV.TABLE_NAME not found' because user STDEV not present in production environment.

I would like to know proper deployment procedure