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.
This requires an operation in the database and should only be done by a database specialist and if you have a backup!
There can be side effects, if there are already deleted documents in the table you used before. You will not be able to access them anymore. So please ensure you don't have any deleted documents before you change the connection.
The database connection is stored in the following table (trashbindbconnection): dwsystem.DWOrganizationDB
Per default, the dwdata is used for this. This is the “Content” database connection. You can basically use every database connection, which has "used for index entries" and "used for document trays" enabled in the DocuWare Administration.
Search for a database connection GUID in the dwsystem.DWSystemSettings table that you want to use.
Then 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]'
It is possible to change the database connection for the trash bin.
This requires an operation in the database and should only be done by a database specialist and if you have a backup!
There can be side effects, if there are already deleted documents in the table you used before. You will not be able to access them anymore. So please ensure you don't have any deleted documents before you change the connection.
The database connection is stored in the following table (trashbindbconnection): dwsystem.DWOrganizationDB
Per default, the dwdata is used for this. This is the “Content” database connection. You can basically use every database connection, which has "used for index entries" and "used for document trays" enabled in the DocuWare Administration.
Search for a database connection GUID in the dwsystem.DWSystemSettings table that you want to use.
Then 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 only applies to OnPremises systems.
