Version 3.6 and SQL Server - Upgrade path?

Discussion of open issues, suggestions and bugs regarding code review tool for Visual Studio – Review Assistant
Post Reply
Jgedney
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Version 3.6 and SQL Server - Upgrade path?

Post by 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?

mstislavs
Devart Team
Posts: 68
Joined: Mon 16 Jan 2017 12:48

Re: Version 3.6 and SQL Server - Upgrade path?

Post by 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

Jgedney
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Re: Version 3.6 and SQL Server - Upgrade path?

Post by 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)

mstislavs
Devart Team
Posts: 68
Joined: Mon 16 Jan 2017 12:48

Re: Version 3.6 and SQL Server - Upgrade path?

Post by 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

Jgedney
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Re: Version 3.6 and SQL Server - Upgrade path?

Post by 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,

mstislavs
Devart Team
Posts: 68
Joined: Mon 16 Jan 2017 12:48

Re: Version 3.6 and SQL Server - Upgrade path?

Post by 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 ... 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

Jgedney
Posts: 6
Joined: Mon 18 Sep 2017 17:51

Re: Version 3.6 and SQL Server - Upgrade path?

Post by Jgedney » Wed 13 Dec 2017 16:47

thank you for the clarification

Post Reply