Can't upgrade database with V11

Can't upgrade database with V11

avatar

Please see below images. I've always used my account for administration so I'm not sure why this is happening. SQL Server 2014 with V11 RDM.

2.PNG

1.PNG

All Comments (5)

avatar

Hi,
Our DBA will help you soon. I have assigned the thread to him.

David Hervieux

avatar

Could you please send us your DB schema for analysis via File -> Data Sources -> Upgrade (tab) -> "Email Schema to Support"

Please add: "Attn: Stefane" in the subject.

I'm away from my computer for the next few hours, but will take a look at it once I get back.

Best regards,

Stéfane Lavergne

avatar

Done

avatar

It looks like the database was might have been migrated using SSMA (SQL Server Migration Assistant). Please run the following SQL script and try to upgrade again via RDM.

alter table dbo.Attachment drop constraint DF__Attachmen__DataS__300424B4
GO

if exists (select * from sys.syscolumns where name = 'DataSourceID' and id = object_id(N'dbo.Attachment'))
alter table dbo.Attachment alter column DataSourceID uniqueidentifier null
GO

alter table dbo.Attachment add constraint DF_Attachment_DataSourceId default ('{00000000-0000-0000-0000-000000000000}') for DataSourceId
GO
Fail or success? Please re-send your database schema for further analysis regardless of outcome, I would like to make sure all is good going forward.

Best regards,

Stéfane Lavergne

avatar

Success! Thanks! Sent you schema.

Closed