Publicado Wed, 02 Mar 2022 14:38:13 GMT por Steve Shriver Application Specialist
In preparing for an upgrade from 6.12 to 7.5 we would like to create a test version of the system first. We want to install the current 6.12 system on a new server using a backup of the production database. The end user wants to put the restored backup on the same SQL Server and rename the databases to avoid conflict with the existing production database.

I do not believe this is possible (or a good idea) but I would like to get an 'official' opinion. Is there a way to accomplish this? Or is it absolutely necessary to use a separate instance of SQL in a case such as this?

Publicado Wed, 02 Mar 2022 15:22:33 GMT por Marcin Kratiuk
DocuWare database is just the definition of the connection to the SQL database. You can have as many different databases as you want. In case of system database docuware will use dwsystem name. During initial setup of the system you should be able to define it.&nbsp;<br> <br> Please note that sql database contains only index fields. It doesn't contain documents. In this scenario you would need also define separate place for document storage and copy documents.&nbsp;<br> <br> If you need to copy configuration and documents between different servers you can try to use this tool:&nbsp;<br> <br> .
Publicado Wed, 02 Mar 2022 15:47:24 GMT por Steve Shriver Application Specialist
Thank you for that info. But just to be clear, we are installing 6.12 to an existing 6.12 Database that is a copy of the production DB using the method described in KBA-35828. Will the installer not find the existing production DB in the same SQL instance and attempt to use it?

For example we will have DWSYSTEM and DWSYSTEM-TEST, DWDATA and DWDATA-TEST, etc. Will we be able to specify the correct DB at installation time?
Publicado Wed, 02 Mar 2022 16:15:21 GMT por Marcin Kratiuk
This way it will NOT WORK as the setup program will try to use the system database which already exists.
Assuming that SQL server is running on the separate machine than DocuWare application server and depending on the size of the database and size of the document storage I would recomend to check the possibility to use separate machine with SQL Express (if it will fit the requirements).
Publicado Wed, 02 Mar 2022 16:47:28 GMT por Steve Shriver Application Specialist

That is what I thought. Thanks again for your help.

You must be signed in to post in this forum.