How to change an AutoPLANT Piping project database to a new SQL Server

These steps only apply to changing the database. More is involved if the AutoPLANT project configuration files or documents change to a new location. However, if only the SQL database is moved, then use the steps below.

  1. First, make sure everyone is out of the AutoPLANT project.
  2. Copy the SQL database to the new server.
  3. Add a SQL user account and make sure it has DBOWNER privileges to the database.
  4. Open Project Administrator.
  5. Go to <project name>\Database\Databases
  6. Now highlight the PROJDATA project database and select "Modify".
  7. A Project Database Properties warning message will appear. Select "Yes".
  8. In the Data Link Properties, it should already be pointing to a SQL Server. If not, change the Provider to "Microsoft OLE DB Provider for SQL Server".
  9. Then, go to the Connection tab.
  10. Type in the new SQL Server name in step 1.
  11. Type in the new SQL Server User Name and Password in step 2 and check the option "allow saving password".
  12. Then select the database on the server and test the connection.
  13. Select OK and then save changes in Project Administrator if necessary.
  • Respected Bentley Team,

    Subject: Want to know how sql server database can be more helpful than MS-access in Bentley application for Piping?

    My question is related to the piping and equipment in Bentley application.

    In our company , we are using MS-Access database for having the piping information of various process drawing.

    We are thinking about to use sql server database , but before that we want following information so that we can take proper decision for database.

    1>  Want to know how sql server can be more helpful than MS-access in Bentley application for Piping?

    2>  How many user can update the same database in same table at a time if we use sql server database?

    3>  What is the exact limitation of "project size"  for MS-access,sql server and oracle? , means want to know exact size of project, so that according to our project size , we can go / think for Sql server or other database.

    4>  Is it possible , If we install Sql server,only on server(workstation) and client on user PC,then accessing from client user's PC only...?

    5>  Can we create/set different user's login access as per their permission level in Sql server, If yes,then let me know how, step by step?

    6> I am creating crystal report for various reports , then How the "i-model Driver for Crystal Reports" can be more helpful? , if yes then please let me know how to use it step by step.