[Approved] MS SQL Database Upgrade (1 Viewer)

[OnkelChris]

Hey guys,

I had a problem on upgrading the database... TVserver wasn't able to do anything database related... So i took a look at the upgrade scripts and saw some dependencies which were casuing failures...

these where the failures:

[SetupTv(1)]:   Exec SQL: ALTER TABLE Program   DROP COLUMN notify
.
.
.
Exec SQL: ALTER TABLE Program   DROP COLUMN notify
[SetupTv(1)]:   ********* SQL statement failed! *********
[SetupTv(1)]:   ********* Error reason: Fehler bei ALTER TABLE DROP COLUMN, da die 'notify'-Spalte in der 'Program'-Tabelle nicht vorhanden ist.
[SetupTv(1)]:   ********* Error code: 4924, Line: 1 *********
[SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN pcrPid
[SetupTv(1)]:   ********* SQL statement failed! *********
[SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_TuningDetail_idChannel' ist vom Spalte-Objekt 'pcrPid' abhängig.
Fehler bei ALTER TABLE DROP COLUMN pcrPid, da mindestens ein Objekt auf diese Spalte zugreift.
[SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
[SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN videoPid
[SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN audioPid
[SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=56
.
.
.
[SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "name"
[SetupTv(1)]:   ********* SQL statement failed! *********
[SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_Channel_IsTV' ist vom Spalte-Objekt 'name' abhängig.
Fehler bei ALTER TABLE DROP COLUMN name, da mindestens ein Objekt auf diese Spalte zugreift.
[SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
[SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "freetoair"
[SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=57

attached a patch for upgrading to version 56 and then 57

EDIT:
after this day, my brain feels empty... i forgot to say, that i use a MS SQL Server 2008 Express SP1 on a Windows7 x86