Skip to main content
1-Visitor
December 29, 2015
Solved

How can I change path to SQL Server (from local to remote) in installed Windchill?

Hello,

Is there any tools to set another path to SQL Server (remote server) in already installed Windchill?

Thanks.

2-Explorer
December 29, 2015

If you have already ported the database to a different SQL Server machine using database administration tools then it is all about updating the database related properties in WT_HOME/db/db.properties

Look for the below properties in there and update it using xconfmanager commands and restart your Windchill Instance. If you are using cognos, then you should export and import cognos db and update the content manager configuration as well.

  • wt.pom.jdbc.database=
  • wt.pom.jdbc.host=
  • wt.pom.jdbc.port=
  • wt.pom.jdbc.service=
  • wt.pom.dbPassword=
  • wt.pom.dbUser

Thank you,

Binesh

2 replies

2-Explorer
December 29, 2015

If you have already ported the database to a different SQL Server machine using database administration tools then it is all about updating the database related properties in WT_HOME/db/db.properties

Look for the below properties in there and update it using xconfmanager commands and restart your Windchill Instance. If you are using cognos, then you should export and import cognos db and update the content manager configuration as well.

  • wt.pom.jdbc.database=
  • wt.pom.jdbc.host=
  • wt.pom.jdbc.port=
  • wt.pom.jdbc.service=
  • wt.pom.dbPassword=
  • wt.pom.dbUser

Thank you,

Binesh

Translate
atemnikov1-VisitorAuthor
1-Visitor
December 30, 2015

THank you!

Translate