Please find below the listed general notes regarding how to manually disconnect the "Plant Project Database" Project from the old ProjectWise Server and then re-connect to a new ProjectWise Server. Please note that this is a general overview and explains procedures that will require a SQL DBA and advanced Bentley Software Administrator. It is best to create backups of all data before migrating.
First time only (every other occurrence of another project being moved should write to the newly create AP_PWMAP and AP_PROP tables):Modifications to PW SQL Server: (Need the SQL Server Admin)
Rename the AP_PROP and AP_PWMAP tables so they are backed up (Example: AP_PROP_BAK)Open the AP_PROP table copy the exact connect string value for CONNECTSTRING PROPVALUE. This will be the very long connection string. We will need this to put in the Project.ini Projdata section pointing back to the standard database.
AutoPLANT Re-setup with Connection String.
If you receive an error that it cannot connect or receive the similar error that the connection string is incorrect then follow the steps below:
If yes and the project is now disconnected from ProjectWise we now have a working disconnected standard Autoplant Project that is ready to be integrated with ProjectWise.
Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this Comments or Corrections?" section. THANK YOU!