PLM Database Migration Considerations

Demand:

The PLM application resides on the same server as the database, and it is now necessary to migrate the database to the database server 10.10.1.10.

There are three instances installed in the 10.10.1.10, MSSQLSERVER, MSSQLSERVER_PLM, Wind.

The example used by PLM is wind

Note the following three points:

1. Check the ports of each instance and discover that the Mssqlserve port number is 1433,wind port number 14331,

2. backing up the database

It is important to note that if you want to detach the database of the test environment from the application, you must back up the database of the test environment to 10.10.1.10 Instead of backing up the formal environment's database to 10.10.1.10.

Because the load configuration is not the same.

3. Database accounts

After restoring the database to 10.10.1.10, create the Wcadmin account, with the same permissions as the previous environment, note that the default schema must select Wcadmin.

If you create a new SQL account such as Test_user to connect to the Wcadmin_seine database, the stored procedures and functions in the database need to be modified in addition to the default schema that must be selected Wcadmin

Modifying the D:\ptc\Windchill_10.1\Windchill\db\db.properties of PLM

PLM Database Migration Considerations