Question:
Is it possible to change the database connection, which is used for the trash bin?
Is it possible to change the database connection, which is used for the trash bin?
Answer:
It is possible to change the database connection for the trash bin. Please ensure you don't have any deleted documents before you change the connection, as you will not be able to access them anymore. The database connection for the trashbin can be found in the following table (trashbindbconnection): dwsystem.DWOrganizationDB.
Note: Before proceeding, this operation should be done by a database specialist. Also, ensure you have a backup of all DocuWare databases.
It is possible to change the database connection for the trash bin. Please ensure you don't have any deleted documents before you change the connection, as you will not be able to access them anymore. The database connection for the trashbin can be found in the following table (trashbindbconnection): dwsystem.DWOrganizationDB.
Note: Before proceeding, this operation should be done by a database specialist. Also, ensure you have a backup of all DocuWare databases.
By default, the dwdata is used for this, which is the “Content” database connection in DocuWare Administration. You can use every database connection that has "used for index entries" and "used for document trays" enabled.
1. Search for a database connection GUID in the DWsystem.DWSystemSettings table that you want to use.
2. Run an update statement in the DWOrganizationDB table for the new trashbindbconnection;
update DWOrganizationDB set trashbindbconnection ='[GUID of the new Database Connection that you intend to use]' where guid ='[GUID of the organization]'
1. Search for a database connection GUID in the DWsystem.DWSystemSettings table that you want to use.
2. Run an update statement in the DWOrganizationDB table for the new trashbindbconnection;
update DWOrganizationDB set trashbindbconnection ='[GUID of the new Database Connection that you intend to use]' where guid ='[GUID of the organization]'
KBA is applicable to On-premises Organizations ONLY.