I am going to upgrade the MS SQL Server that runs my Continua database to version 2016 . Should I change the connection string in continua configuration file? Thanks
Hi Sergey,
Providing the SQL server instance name is the same then you should not need to change the connection string in the configuration file.
The dialect property in the configuration file e.g.
<property name=“dialect”>NHibernate.Dialect.MsSql2008Dialectproperty>defines how the NHibernate, which we use as our database ORM, interacts with the database.
Currently this can be set to NHibernate.Dialect.MsSql2005Dialect or NHibernate.Dialect.MsSql2008Dialect. The value MsSql2008Dialect works with SQL Server version 2008 and later including SQL Server 2016.
We have recently upgraded the NHibernate component and this now includes a MsSql2012Dialect dialect. We are in the process of updating our code to support this dialect for the next version. Once this is released we will recommend changing the dialect to MsSql2012Dialect.
Note that the configuration file is by default located at %Program Files%\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config