Page 1 of 1

Version 3.6 and SQL Server - Upgrade path?

Posted: Mon 30 Oct 2017 20:37
by Jgedney
I haven't seen this in the online docs regarding the new SQL Server compatible version of ReviewAssistant:
Is there an upgrade tool that will import the existing review data from the local file storage to the SQL Server database?
We are going to need to have the old data somehow.

any advice?

Re: Version 3.6 and SQL Server - Upgrade path?

Posted: Wed 01 Nov 2017 10:31
by mstislavs
Hi,

Thank you for the question. Do you want to use the MS SQL Server 2017 ?


Best regards,
Mstislav Sakidon
Devart Team
www.devart.com

Re: Version 3.6 and SQL Server - Upgrade path?

Posted: Wed 08 Nov 2017 16:31
by Jgedney
We are currently on MSSQL Server 2014 on that box.

We may be upgrading soon, but it may not be for a while after our planned implementation for the new Review assistant. ( we are planning on this change to use the MSSQL "AlwaysON" functionality for our failure contingency planning)

Re: Version 3.6 and SQL Server - Upgrade path?

Posted: Tue 14 Nov 2017 11:28
by mstislavs
If you want to use the "AlwaysON" functionality in MSSQL, we recommend you to install the latest version of Review Assistant server because this release contains a few important bug fixes for this server mode.
If you need to move the database to the new MSSQL server version, you should perform a backup from the old server and restore to a new SQL server.

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com

Re: Version 3.6 and SQL Server - Upgrade path?

Posted: Mon 04 Dec 2017 14:49
by Jgedney
this is not answering my question.
If I do go to a new SQL based server then I need to know if there's a way to import my existing SQLLite data to the MSSQL server so all our existing reviews and users aren't lost in the changeover,

Re: Version 3.6 and SQL Server - Upgrade path?

Posted: Tue 05 Dec 2017 09:43
by mstislavs
Hi

The Review Assistant Server has a special tool for migrating an old SQLite database (Review Assistant v.3.2 and older) to a new empty MS SQL database (Review Assistant 3.5 or higher). This tool is started automatically during the first run of the server.
See more about upgrading the RA server here
https://www.devart.com/review-assistant ... igher.html
The server machine requirements are described here:
https://www.devart.com/review-assistant ... ments.html

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com

Re: Version 3.6 and SQL Server - Upgrade path?

Posted: Wed 13 Dec 2017 16:47
by Jgedney
thank you for the clarification