Announcement

Migration of this forum

Dear users of this forum,

we are pleased to inform you that we will be updating the software behind this forum in the near future.

Existing posts, users and categories will remain untouched.

Important:

  • Each user will need to reset their password.
  • Please select "I forgot my password".
  • Enter the email address you used to register in this forum.
  • You will receive an email with a link to set a new password.
  • Please choose a new (secure) password and confirm the process.

We will keep you informed in the pinned thread.

Kind regards,
Your ReportServer Team

Migration des Forums

Liebe Nutzer dieses Forums,

wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.

Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!

Wichtig:

  • Jeder Nutzer muss sein Passwort neu vergeben.
  • Wählt dazu einfach "Ich habe mein Passwort vergessen".
  • Gebt die E-Mail-Adresse ein, mit der ihr registriert seid.
  • Ihr erhaltet eine E-Mail mit einem Link zur Passwortvergabe.
  • Bitte wählt ein neues (sicheres) Passwort und bestätigt den Vorgang.

Wir halten euch im angepinnten Beitrag auf dem Laufenden!

Mit vielen Grüßen
Euer ReportServer Team

Pages: 1

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

pericajakimov
Member
Registered: 2017-02-09

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

IF_Eduardo
Administrator
Registered: 2016-11-01
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

Pages: 1

Board footer

Powered by FluxBB