upgrading from db 4.5.3103 and want to go to 4.7.40.4545
the first folder after 4.5.3016.35 (have higher version than that) is 4.7.40.3321, so I guess I need to run those SQL scripts first
in there, I see 00. Change calendar event.sql which throws error at
CREATE TABLE dbo.CalendarEventEntry
(
CalendarId uniqueidentifier NOT NULL,
CalendarEventId uniqueidentifier NOT NULL
) ON [PRIMARY]
Msg 207, Level 16, State 1, Line 40
Invalid column name 'CalendarId'.
this is logical since the table already exists and has the following fields: CalendarId, CalendarEventId, IsBusy (bit, not null)
- should I delete the old table (it's empty, although the CalendarEvent table has some entries, not sure what that extra table is for)?
</br>
- what about the "isBusy" column? the new script doesn't seem to create such column
</br>
</br>