0

Hi we will like to migrate from mspcontrol 1.0 to solidcp
but then i run the db script i get thi errors
can you help me with the error and i this is expect

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 701).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 702).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 703).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 704).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 705).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 706).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_HostingPlanQuotas_1’. Cannot insert duplicate key in object ‘dbo.HostingPlanQuotas’. The duplicate key value is (49, 707).
The statement has been terminated.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint “FK_Quotas_ServiceItemTypes”. The conflict occurred in database “mspcontrol”, table “dbo.Quotas”, column ‘ItemTypeID’.
The statement has been terminated.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 3
The DELETE statement conflicted with the REFERENCE constraint “FK_Quotas_ServiceItemTypes”. The conflict occurred in database “mspcontrol”, table “dbo.Quotas”, column ‘ItemTypeID’.
The statement has been terminated.

(0 row(s) affected)
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.

(0 row(s) affected)
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view ‘dbo.UsersDetailed’, because it does not exist or you do not have permission.
Msg 2714, Level 16, State 3, Procedure SearchServiceItemsPaged, Line 2
There is already an object named ‘SearchServiceItemsPaged’ in the database.
Msg 547, Level 16, State 0, Line 3
The DELETE statement conflicted with the REFERENCE constraint “FK_HostingPlanQuotas_Quotas”. The conflict occurred in database “mspcontrol”, table “dbo.HostingPlanQuotas”, column ‘QuotaID’.
The statement has been terminated.

(3 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The DELETE statement conflicted with the REFERENCE constraint “FK_Providers_ResourceGroups”. The conflict occurred in database “mspcontrol”, table “dbo.Providers”, column ‘GroupID’.
The statement has been terminated.

Answered question