#1 2018-10-29 21:01:57

pericajakimov
Member
Registered: 2017-02-09
Posts: 3

Upgrade SQL server DB

Hi,

I have installed Community edition 3.0.2 and at the time of installation (about 2 years ago) I remember that I had a problem with the sql script that creates the DB schema. I'm using SQL server 2008R2. At that time I fixed the problem manually and the server is working good.
Now I want to do an upgrade to the newest version 3.0.4, and the upgrade scripts did not execute. Than I saw the same problem again, the scripts are braking at:
INSERT INTO RS_SCHEMAINFO(KEY_FIELD, value) VALUES('updated', format(getdate(), 'yyyy-MM-dd HH:mm:ss'));

The FORMAT function is not available at SQL Server before 2012, so to have full support i think it is better to use:
INSERT INTO RS_SCHEMAINFO(KEY_FIELD, value) VALUES('updated', convert(varchar, getdate(), 120));

The CONVERT function is a much more universal solution.
If you agree with me please update the Sql server scripts.

Thanks,
Perica

Offline

#2 2018-11-02 12:30:39

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Upgrade SQL server DB

Hi Perica,

thanks for pointing this out. I raised issue RS-3107 and we will look into this.
We cannot change previous versions, since these versions are out and they cannot be modified. But we will look at this for next versions.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB