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?

  • December 29, 2015
  • 1 reply
  • 1340 views

Hello,

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

Thanks.

Best answer by BineshKumar1

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

1 reply

1-Visitor
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

atemnikov1-VisitorAuthor
1-Visitor
December 30, 2015

THank you!