Version 3.6 and SQL Server - Upgrade path?

Version 3.6 and SQL Server - Upgrade path?

Postby Jgedney » Mon 30 Oct 2017 20:37

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?
Jgedney
 
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Re: Version 3.6 and SQL Server - Upgrade path?

Postby mstislavs » Wed 01 Nov 2017 10:31

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
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Version 3.6 and SQL Server - Upgrade path?

Postby Jgedney » Wed 08 Nov 2017 16:31

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)
Jgedney
 
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Re: Version 3.6 and SQL Server - Upgrade path?

Postby mstislavs » Tue 14 Nov 2017 11:28

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
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Version 3.6 and SQL Server - Upgrade path?

Postby Jgedney » Mon 04 Dec 2017 14:49

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,
Jgedney
 
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Re: Version 3.6 and SQL Server - Upgrade path?

Postby mstislavs » Tue 05 Dec 2017 09:43

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/docs/index.html?how_to_update_to_review_assistant_35_or_higher.html
The server machine requirements are described here:
https://www.devart.com/review-assistant/docs/system_requirements.html

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Version 3.6 and SQL Server - Upgrade path?

Postby Jgedney » Wed 13 Dec 2017 16:47

thank you for the clarification
Jgedney
 
Posts: 6
Joined: Mon 18 Sep 2017 17:51


Return to Review Assistant