请问这个问题怎么解决?
我的迁移步骤如下:(迷你版12.0到专业版15.0到旗舰版2.0到K3WISE)
1.用2018工具迁移到专业版15.0;---成功
2.用2017工具迁移到旗舰版2.0;---成功
3.用2018工具迁移到K3WISE.---失败(如下图及迁移日志)

------以下是迁移日志------

数据库实体 : KISTOAIS20180519024145

执行文件C:\Kingstyle_Bak\2018KIS旗舰版迁移WISE工具V1.0\KISUpdradeWISE\SqlSrv\PT02897101.sql出错。
错误描述:ALTER TABLE 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"KISTOAIS20180519024145"，表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_PL_PA_FK_HR_PL_T_PAITEM' AND xtype = 'F')
ALTER TABLE [HR_PL_SLItem] ADD CONSTRAINT [FK_HR_PL_PA_FK_HR_PL_T_PAITEM] FOREIGN KEY ([FItemID]) REFERENCES [t_PAItem] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_HRInit_REC_BaseInfo' AND xtype = 'F')
ALTER TABLE [REC_InterviewOpinion_HRInit] ADD CONSTRAINT [FK_REC_InterviewOpinion_HRInit_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_BUSIT' AND xtype = 'F')
ALTER TABLE [AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_BUSIT] FOREIGN KEY ([BusiTypeID]) REFERENCES [AP_BusiType] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_ITEM' AND xtype = 'F')
ALTER TABLE [AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_ITEM] FOREIGN KEY ([ItemID]) REFERENCES [AP_Item] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_FItemClassID' AND xtype = 'F')
ALTER TABLE [t_Item] ADD CONSTRAINT [FK_FItemClassID] FOREIGN KEY ([FItemClassID]) REFERENCES [t_ItemClass] ([FItemClassID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'fk_ItemParent' AND xtype = 'F')
ALTER TABLE [t_Item] ADD CONSTRAINT [fk_ItemParent] FOREIGN KEY ([FParentID]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_POSI_FK_ORG_PO_ORG_POS2' AND xtype = 'F')
ALTER TABLE [ORG_Position] ADD CONSTRAINT [FK_ORG_POSI_FK_ORG_PO_ORG_POS2] FOREIGN KEY ([ParentID]) REFERENCES [ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_OM_Task' AND xtype = 'F')
ALTER TABLE [T_OM_Task] ADD CONSTRAINT [FK_T_OM_Task] FOREIGN KEY ([FCSFID]) REFERENCES [T_OM_CSF] ([FCSFID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_CSF_EntStrategyItem' AND xtype = 'F')
ALTER TABLE [T_OM_CSF] ADD CONSTRAINT [FK_CSF_EntStrategyItem] FOREIGN KEY ([FEntStrategyItemID]) REFERENCES [T_OM_EntStrategyItem] ([FEntStrategyItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM' AND xtype = 'F')
ALTER TABLE [ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM] FOREIGN KEY ([FrameworkID]) REFERENCES [ORG_Framework] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_UNIT] FOREIGN KEY ([StatusID]) REFERENCES [ORG_UnitStatus] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'uk_PA_ItemPropDesc' AND xtype = 'UQ')
ALTER TABLE [t_PA_ItemPropDesc] ADD CONSTRAINT uk_PA_ItemPropDesc UNIQUE (FItemClassID, FName)

执行文件C:\Kingstyle_Bak\2018KIS旗舰版迁移WISE工具V1.0\KISUpdradeWISE\SqlSrv\PT02897102.sql出错。
错误描述:ALTER TABLE 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"KISTOAIS20180519024145"，表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlInputFiles_Frm_HtmlInputControls' AND xtype = 'F')
ALTER TABLE [Frm_HtmlInputFiles] ADD CONSTRAINT [FK_Frm_HtmlInputFiles_Frm_HtmlInputControls] FOREIGN KEY ([Id]) REFERENCES [Frm_HtmlInputControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlInputControls_Frm_HtmlControls' AND xtype = 'F')
ALTER TABLE [Frm_HtmlInputControls] ADD CONSTRAINT [FK_Frm_HtmlInputControls_Frm_HtmlControls] FOREIGN KEY ([Id]) REFERENCES [Frm_HtmlControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_WfRPrDef_PgDef' AND xtype = 'F')
ALTER TABLE [T_WF_RunProcessDef] ADD CONSTRAINT [FK_WfRPrDef_PgDef] FOREIGN KEY ([FPackageId]) REFERENCES [T_WF_RunPackageDef] ([FPackageId])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_WfRProcDef_XDoc' AND xtype = 'F')
ALTER TABLE [T_WF_RunProcessDef] ADD CONSTRAINT [FK_WfRProcDef_XDoc] FOREIGN KEY ([FDocumentId]) REFERENCES [T_WF_RunXpdlDocument] ([FId])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_FABalOrgFor_t_FABalance' AND xtype = 'F')
ALTER TABLE [t_FABalOrgFor] ADD CONSTRAINT [FK_t_FABalOrgFor_t_FABalance] FOREIGN KEY ([FBalID]) REFERENCES [t_FABalance] ([FBalID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_DEPA_FK_ORG_DE_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [ORG_Department] ADD CONSTRAINT [FK_ORG_DEPA_FK_ORG_DE_ORG_UNIT] FOREIGN KEY ([UnitID]) REFERENCES [ORG_Unit] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_DEPA_REFERENCE_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [ORG_Department] ADD CONSTRAINT [FK_ORG_DEPA_REFERENCE_ORG_UNIT] FOREIGN KEY ([CompanyID]) REFERENCES [ORG_Unit] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_COMP_FK_ORG_CO_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [ORG_Company] ADD CONSTRAINT [FK_ORG_COMP_FK_ORG_CO_ORG_UNIT] FOREIGN KEY ([UnitID]) REFERENCES [ORG_Unit] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_COMP_REFERENCE_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [ORG_Company] ADD CONSTRAINT [FK_ORG_COMP_REFERENCE_ORG_UNIT] FOREIGN KEY ([ParentID]) REFERENCES [ORG_Unit] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_PL_PA_FK_HR_PL_T_PAITEM' AND xtype = 'F')
ALTER TABLE [HR_PL_SLItem] ADD CONSTRAINT [FK_HR_PL_PA_FK_HR_PL_T_PAITEM] FOREIGN KEY ([FItemID]) REFERENCES [t_PAItem] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_HRInit_REC_BaseInfo' AND xtype = 'F')
ALTER TABLE [REC_InterviewOpinion_HRInit] ADD CONSTRAINT [FK_REC_InterviewOpinion_HRInit_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_BUSIT' AND xtype = 'F')
ALTER TABLE [AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_BUSIT] FOREIGN KEY ([BusiTypeID]) REFERENCES [AP_BusiType] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_ITEM' AND xtype = 'F')
ALTER TABLE [AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_ITEM] FOREIGN KEY ([ItemID]) REFERENCES [AP_Item] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_FItemClassID' AND xtype = 'F')
ALTER TABLE [t_Item] ADD CONSTRAINT [FK_FItemClassID] FOREIGN KEY ([FItemClassID]) REFERENCES [t_ItemClass] ([FItemClassID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'fk_ItemParent' AND xtype = 'F')
ALTER TABLE [t_Item] ADD CONSTRAINT [fk_ItemParent] FOREIGN KEY ([FParentID]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_POSI_FK_ORG_PO_ORG_POS2' AND xtype = 'F')
ALTER TABLE [ORG_Position] ADD CONSTRAINT [FK_ORG_POSI_FK_ORG_PO_ORG_POS2] FOREIGN KEY ([ParentID]) REFERENCES [ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_OM_Task' AND xtype = 'F')
ALTER TABLE [T_OM_Task] ADD CONSTRAINT [FK_T_OM_Task] FOREIGN KEY ([FCSFID]) REFERENCES [T_OM_CSF] ([FCSFID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_CSF_EntStrategyItem' AND xtype = 'F')
ALTER TABLE [T_OM_CSF] ADD CONSTRAINT [FK_CSF_EntStrategyItem] FOREIGN KEY ([FEntStrategyItemID]) REFERENCES [T_OM_EntStrategyItem] ([FEntStrategyItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM' AND xtype = 'F')
ALTER TABLE [ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM] FOREIGN KEY ([FrameworkID]) REFERENCES [ORG_Framework] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_UNIT] FOREIGN KEY ([StatusID]) REFERENCES [ORG_UnitStatus] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'uk_PA_ItemPropDesc' AND xtype = 'UQ')
ALTER TABLE [t_PA_ItemPropDesc] ADD CONSTRAINT uk_PA_ItemPropDesc UNIQUE (FItemClassID, FName)
IF NOT EXISTS(SELECT FValue FROM t_systemprofile WHERE fcategory='GL' AND fkey='GaSystem' AND fvalue='1')
BEGIN
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgAcctRelation_FMGAcctID' AND xtype = 'F')
ALTER TABLE [t_MgAcctRelation] ADD CONSTRAINT [FK_t_MgAcctRelation_FMGAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgMultiCheckMoney_FBillType' AND xtype = 'F')
ALTER TABLE [t_MgMultiCheckMoney] ADD CONSTRAINT [FK_t_MgMultiCheckMoney_FBillType] FOREIGN KEY ([FBillType]) REFERENCES [t_MgMultiCheckOption] ([FBillType])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FCurrencyID' AND xtype = 'F')
ALTER TABLE [ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FCurrencyID] FOREIGN KEY ([FCurrencyID]) REFERENCES [t_Currency] ([FCurrencyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FDepartment' AND xtype = 'F')
ALTER TABLE [ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FDepartment] FOREIGN KEY ([FDepartment]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FEmployee' AND xtype = 'F')
ALTER TABLE [ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FEmployee] FOREIGN KEY ([FEmployee]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FVendor' AND xtype = 'F')
ALTER TABLE [ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FVendor] FOREIGN KEY ([FVendor]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgSuperAprove_FBillType' AND xtype = 'F')
ALTER TABLE [t_MgSuperAprove] ADD CONSTRAINT [FK_t_MgSuperAprove_FBillType] FOREIGN KEY ([FBillType]) REFERENCES [t_MgBillType] ([FBillType])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgMultiCheckLevel_FBillType' AND xtype = 'F')
ALTER TABLE [t_MgMultiCheckLevel] ADD CONSTRAINT [FK_t_MgMultiCheckLevel_FBillType] FOREIGN KEY ([FBillType]) REFERENCES [t_MgMultiCheckOption] ([FBillType])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgAlertUser_FMgAcctID' AND xtype = 'F')
ALTER TABLE [t_MgAlertUser] ADD CONSTRAINT [FK_t_MgAlertUser_FMgAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Risk_RiskTrail' AND xtype = 'F')
ALTER TABLE [T_OM_RiskTrail] ADD CONSTRAINT [FK_Risk_RiskTrail] FOREIGN KEY ([FRiskID]) REFERENCES [T_OM_Risk] ([FRiskID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Risk_BSC' AND xtype = 'F')
ALTER TABLE [T_OM_Risk] ADD CONSTRAINT [FK_Risk_BSC] FOREIGN KEY ([FBSCID]) REFERENCES [T_OM_BSC] ([FBSCID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgItem_FMgAcctID' AND xtype = 'F')
ALTER TABLE [t_MgItem] ADD CONSTRAINT [FK_t_MgItem_FMgAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBudVchHook_FBillID' AND xtype = 'F')
ALTER TABLE [t_MgBudVchHook] ADD CONSTRAINT [FK_t_MgBudVchHook_FBillID] FOREIGN KEY ([FBillID]) REFERENCES [t_MgBill] ([FBillID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgAlertSet_FMgAcctID' AND xtype = 'F')
ALTER TABLE [t_MgAlertSet] ADD CONSTRAINT [FK_t_MgAlertSet_FMgAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBudModifyDetail_FModifyID' AND xtype = 'F')
ALTER TABLE [t_MgBudModifyDetail] ADD CONSTRAINT [FK_t_MgBudModifyDetail_FModifyID] FOREIGN KEY ([FModifyID]) REFERENCES [t_MgBudgetModify] ([FModifyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBudget_FCenterID' AND xtype = 'F')
ALTER TABLE [t_MgBudget] ADD CONSTRAINT [FK_t_MgBudget_FCenterID] FOREIGN KEY ([FCenterID]) REFERENCES [t_MgCenter] ([FCenterID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgBudget_FMGAcctID' AND xtype = 'F')
ALTER TABLE [t_MgBudget] ADD CONSTRAINT [FK_t_mgBudget_FMGAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgBudget_FProjectID' AND xtype = 'F')
ALTER TABLE [t_MgBudget] ADD CONSTRAINT [FK_t_mgBudget_FProjectID] FOREIGN KEY ([FProjectID]) REFERENCES [t_MgBudgetSet] ([FProjectID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgBudgetModify_FBudgetID' AND xtype = 'F')
ALTER TABLE [t_MgBudgetModify] ADD CONSTRAINT [FK_t_mgBudgetModify_FBudgetID] FOREIGN KEY ([FBudgetID]) REFERENCES [t_MgBudget] ([FBudgetID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgAproAdjust_FBudgetID' AND xtype = 'F')
ALTER TABLE [t_MgAproAdjust] ADD CONSTRAINT [FK_t_MgAproAdjust_FBudgetID] FOREIGN KEY ([FBudgetID]) REFERENCES [t_MgBudget] ([FBudgetID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgBudgetDetail_FBudgetID' AND xtype = 'F')
ALTER TABLE [t_MgBudgetDetail] ADD CONSTRAINT [FK_t_mgBudgetDetail_FBudgetID] FOREIGN KEY ([FBudgetID]) REFERENCES [t_MgBudget] ([FBudgetID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgRealData_FProjectID' AND xtype = 'F')
ALTER TABLE [t_MgRecive] ADD CONSTRAINT [FK_t_MgRealData_FProjectID] FOREIGN KEY ([FProjectID]) REFERENCES [t_MgBudgetSet] ([FProjectID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgRecive_FCenterID' AND xtype = 'F')
ALTER TABLE [t_MgRecive] ADD CONSTRAINT [FK_t_MgRecive_FCenterID] FOREIGN KEY ([FCenterID]) REFERENCES [t_MgCenter] ([FCenterID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgAproAdjust_FAproLogID' AND xtype = 'F')
ALTER TABLE [t_MgAproAdjust] ADD CONSTRAINT [FK_t_MgAproAdjust_FAproLogID] FOREIGN KEY ([FAproLogID]) REFERENCES [t_MgAproLog] ([FAproLogID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgRealData_FCenterID' AND xtype = 'F')
ALTER TABLE [t_MgRealData] ADD CONSTRAINT [FK_t_MgRealData_FCenterID] FOREIGN KEY ([FCenterID]) REFERENCES [t_MgCenter] ([FCenterID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgRealData_FMgAcctID' AND xtype = 'F')
ALTER TABLE [t_MgRealData] ADD CONSTRAINT [FK_t_MgRealData_FMgAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgRelation_FMgAcctID' AND xtype = 'F')
ALTER TABLE [t_MgRelation] ADD CONSTRAINT [FK_t_MgRelation_FMgAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_MeasureValue_MEASURE' AND xtype = 'F')
ALTER TABLE [T_OM_MeasureValue] ADD CONSTRAINT [FK_MeasureValue_MEASURE] FOREIGN KEY ([FMeasureID]) REFERENCES [T_OM_MEASURE] ([FMeasureID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_OM_MeasureValue_T_TimeByDay' AND xtype = 'F')
ALTER TABLE [T_OM_MeasureValue] ADD CONSTRAINT [FK_T_OM_MeasureValue_T_TimeByDay] FOREIGN KEY ([FTimeID]) REFERENCES [T_TimeByDay] ([FTime_id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgMultiCheckRecord_FBillID' AND xtype = 'F')
ALTER TABLE [t_MgMultiCheckRecord] ADD CONSTRAINT [FK_t_MgMultiCheckRecord_FBillID] FOREIGN KEY ([FBillID]) REFERENCES [t_MgBill] ([FBillID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBill_FBillType' AND xtype = 'F')
ALTER TABLE [t_MgBill] ADD CONSTRAINT [FK_t_MgBill_FBillType] FOREIGN KEY ([FBillType]) REFERENCES [t_MgBillType] ([FBillType])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBill_FMGAcctID' AND xtype = 'F')
ALTER TABLE [t_MgBill] ADD CONSTRAINT [FK_t_MgBill_FMGAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgMultiCheckOption_FBillType' AND xtype = 'F')
ALTER TABLE [t_MgBill] ADD CONSTRAINT [FK_t_MgMultiCheckOption_FBillType] FOREIGN KEY ([FBillType]) REFERENCES [t_MgBillType] ([FBillType])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgGrBudgetDetail_FBudgetID' AND xtype = 'F')
ALTER TABLE [t_MgGrBudgetDetail] ADD CONSTRAINT [FK_t_mgGrBudgetDetail_FBudgetID] FOREIGN KEY ([FBudgetID]) REFERENCES [t_MgGrBudget] ([FBudgetID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgGrBudget_FMGAcctID' AND xtype = 'F')
ALTER TABLE [t_MgGrBudget] ADD CONSTRAINT [FK_t_mgGrBudget_FMGAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_mgGrBudget_FProjectID' AND xtype = 'F')
ALTER TABLE [t_MgGrBudget] ADD CONSTRAINT [FK_t_mgGrBudget_FProjectID] FOREIGN KEY ([FProjectID]) REFERENCES [t_MgBudgetSet] ([FProjectID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgAproLog_FProjectID' AND xtype = 'F')
ALTER TABLE [t_MgAproLog] ADD CONSTRAINT [FK_t_MgAproLog_FProjectID] FOREIGN KEY ([FProjectID]) REFERENCES [t_MgBudgetSet] ([FProjectID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_EntStrategy_Item' AND xtype = 'F')
ALTER TABLE [T_OM_EntStrategyItem] ADD CONSTRAINT [FK_EntStrategy_Item] FOREIGN KEY ([FEntStrategyID]) REFERENCES [T_OM_EntStrategy] ([FEntStrategyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Affiliates_Vendors' AND xtype = 'F')
ALTER TABLE [Affiliates] WITH NOCHECK ADD CONSTRAINT [FK_Affiliates_Vendors] FOREIGN KEY ([VendorId]) REFERENCES [Vendors] ([VendorId]) ON DELETE CASCADE NOT FOR REPLICATION
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgFormulaEx_FMgAcctID' AND xtype = 'F')
ALTER TABLE [t_MgFormulaEx] ADD CONSTRAINT [FK_t_MgFormulaEx_FMgAcctID] FOREIGN KEY ([FMgAcctID]) REFERENCES [t_MgAcct] ([FMgAcctID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_MEASURE_KPI' AND xtype = 'F')
ALTER TABLE [T_OM_MEASURE] ADD CONSTRAINT [FK_MEASURE_KPI] FOREIGN KEY ([FKPIID]) REFERENCES [T_OM_KPI] ([FKPIID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_STInvoice_FCurrencyID' AND xtype = 'F')
ALTER TABLE [STInvoice] ADD CONSTRAINT [FK_STInvoice_FCurrencyID] FOREIGN KEY ([FCurrencyID]) REFERENCES [t_Currency] ([FCurrencyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_STInvoice_FCustomer' AND xtype = 'F')
ALTER TABLE [STInvoice] ADD CONSTRAINT [FK_STInvoice_FCustomer] FOREIGN KEY ([FCustomer]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_STInvoice_FDepartment' AND xtype = 'F')
ALTER TABLE [STInvoice] ADD CONSTRAINT [FK_STInvoice_FDepartment] FOREIGN KEY ([FDepartment]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_STInvoice_FSalerGroup' AND xtype = 'F')
ALTER TABLE [STInvoice] ADD CONSTRAINT [FK_STInvoice_FSalerGroup] FOREIGN KEY ([FSalerGroup]) REFERENCES [t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_UserPortals_Portals' AND xtype = 'F')
ALTER TABLE [UserPortals] WITH NOCHECK ADD CONSTRAINT [FK_UserPortals_Portals] FOREIGN KEY ([PortalId]) REFERENCES [Portals] ([PortalID]) ON DELETE CASCADE NOT FOR REPLICATION
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_UserPortals_Users' AND xtype = 'F')
ALTER TABLE [UserPortals] WITH NOCHECK ADD CONSTRAINT [FK_UserPortals_Users] FOREIGN KEY ([UserId]) REFERENCES [Users] ([UserID]) ON DELETE CASCADE NOT FOR REPLICATION
END

执行文件C:\Kingstyle_Bak\2018KIS旗舰版迁移WISE工具V1.0\KISUpdradeWISE\SqlSrv\PT02897103.sql出错。
错误描述:ALTER TABLE 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"KISTOAIS20180519024145"，表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_BUSIT' AND xtype = 'F')
ALTER TABLE [dbo].[AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_BUSIT] FOREIGN KEY ([BusiTypeID]) REFERENCES [dbo].[AP_BusiType] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_ITEM' AND xtype = 'F')
ALTER TABLE [dbo].[AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_ITEM] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[AP_Item] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_FItemClassID' AND xtype = 'F')
ALTER TABLE [dbo].[t_Item] ADD CONSTRAINT [FK_FItemClassID] FOREIGN KEY ([FItemClassID]) REFERENCES [dbo].[t_ItemClass] ([FItemClassID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'fk_ItemParent' AND xtype = 'F')
ALTER TABLE [dbo].[t_Item] ADD CONSTRAINT [fk_ItemParent] FOREIGN KEY ([FParentID]) REFERENCES [dbo].[t_Item] ([FItemID])

执行文件C:\Kingstyle_Bak\2018KIS旗舰版迁移WISE工具V1.0\KISUpdradeWISE\SqlSrv\PT02897104.sql出错。
错误描述:ALTER TABLE 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"KISTOAIS20180519024145"，表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_BUSIT' AND xtype = 'F')
ALTER TABLE [dbo].[AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_BUSIT] FOREIGN KEY ([BusiTypeID]) REFERENCES [dbo].[AP_BusiType] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_ITEM' AND xtype = 'F')
ALTER TABLE [dbo].[AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_ITEM] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[AP_Item] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_FItemClassID' AND xtype = 'F')
ALTER TABLE [dbo].[t_Item] ADD CONSTRAINT [FK_FItemClassID] FOREIGN KEY ([FItemClassID]) REFERENCES [dbo].[t_ItemClass] ([FItemClassID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'fk_ItemParent' AND xtype = 'F')
ALTER TABLE [dbo].[t_Item] ADD CONSTRAINT [fk_ItemParent] FOREIGN KEY ([FParentID]) REFERENCES [dbo].[t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_POSI_FK_ORG_PO_ORG_POS2' AND xtype = 'F')
ALTER TABLE [dbo].[ORG_Position] ADD CONSTRAINT [FK_ORG_POSI_FK_ORG_PO_ORG_POS2] FOREIGN KEY ([ParentID]) REFERENCES [dbo].[ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM' AND xtype = 'F')
ALTER TABLE [dbo].[ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM] FOREIGN KEY ([FrameworkID]) REFERENCES [dbo].[ORG_Framework] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_UNIT' AND xtype = 'F')
ALTER TABLE [dbo].[ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_UNIT] FOREIGN KEY ([StatusID]) REFERENCES [dbo].[ORG_UnitStatus] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'uk_PA_ItemPropDesc' AND xtype = 'UQ')
ALTER TABLE [dbo].[t_PA_ItemPropDesc] ADD CONSTRAINT [uk_PA_ItemPropDesc] UNIQUE (FItemClassID, FName)

执行文件C:\Kingstyle_Bak\2018KIS旗舰版迁移WISE工具V1.0\KISUpdradeWISE\SqlSrv\PT02897105.sql出错。
错误描述:ALTER TABLE 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"KISTOAIS20180519024145"，表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_PL_PA_FK_HR_PL_T_PAITEM' AND xtype = 'F')
ALTER TABLE [dbo].[HR_PL_SLItem] ADD CONSTRAINT [FK_HR_PL_PA_FK_HR_PL_T_PAITEM] FOREIGN KEY ([FItemID]) REFERENCES [dbo].[t_PAItem] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_HRInit_REC_BaseInfo' AND xtype = 'F')
ALTER TABLE [dbo].[REC_InterviewOpinion_HRInit] ADD CONSTRAINT [FK_REC_InterviewOpinion_HRInit_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_BUSIT' AND xtype = 'F')
ALTER TABLE [dbo].[AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_BUSIT] FOREIGN KEY ([BusiTypeID]) REFERENCES [dbo].[AP_BusiType] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_BUSII_REFERENCE_AP_ITEM' AND xtype = 'F')
ALTER TABLE [dbo].[AP_BusiItem] ADD CONSTRAINT [FK_AP_BUSII_REFERENCE_AP_ITEM] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[AP_Item] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_FItemClassID' AND xtype = 'F')
ALTER TABLE [dbo].[t_Item] ADD CONSTRAINT [FK_FItemClassID] FOREIGN KEY ([FItemClassID]) REFERENCES [dbo].[t_ItemClass] ([FItemClassID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'fk_ItemParent' AND xtype = 'F')
ALTER TABLE [dbo].[t_Item] ADD CONSTRAINT [fk_ItemParent] FOREIGN KEY ([FParentID]) REFERENCES [dbo].[t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_POSI_FK_ORG_PO_ORG_POS2' AND xtype = 'F')
ALTER TABLE [dbo].[ORG_Position] ADD CONSTRAINT [FK_ORG_POSI_FK_ORG_PO_ORG_POS2] FOREIGN KEY ([ParentID]) REFERENCES [dbo].[ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_OM_Task' AND xtype = 'F')
ALTER TABLE [dbo].[T_OM_Task] ADD CONSTRAINT [FK_T_OM_Task] FOREIGN KEY ([FCSFID]) REFERENCES [dbo].[T_OM_CSF] ([FCSFID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM' AND xtype = 'F')
ALTER TABLE [dbo].[ORG_Unit] ADD CONSTRAINT [FK_ORG_UNIT_FK_ORG_UN_ORG_FRAM] FOREIGN KEY ([FrameworkID]) REFERENCES [dbo].[ORG_Framework] ([ID])

执行文件C:\Kingstyle_Bak\2018KIS旗舰版迁移WISE工具V1.0\KISUpdradeWISE\SqlSrv\PT02897106.sql出错。
错误描述:ALTER TABLE 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"KISTOAIS20180519024145"，表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_Skills_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_Skills] ADD CONSTRAINT [FK_REC_App_Skills_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_CollectActor_AP_CollectSolution'AND xtype = 'F')
ALTER TABLE [dbo].[AP_CollectActor] ADD CONSTRAINT [FK_AP_CollectActor_AP_CollectSolution] FOREIGN KEY ([CollectSolutionID]) REFERENCES [dbo].[AP_CollectSolution] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_APD_OBJE_REFERENCE_APD_OBJE'AND xtype = 'F')
ALTER TABLE [dbo].[APD_Objective_Role] ADD CONSTRAINT [FK_APD_OBJE_REFERENCE_APD_OBJE] FOREIGN KEY ([FRoleSchemaID]) REFERENCES [dbo].[APD_Objective_RoleSchema] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRIndex_SendDate_HRIndex_MailSettingScheme'AND xtype = 'F')
ALTER TABLE [dbo].[HRIndex_SendDate] ADD CONSTRAINT [FK_HRIndex_SendDate_HRIndex_MailSettingScheme] FOREIGN KEY ([MailSettingID]) REFERENCES [dbo].[HRIndex_MailSettingScheme] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_CheckBoxes_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_CheckBoxes] ADD CONSTRAINT [FK_Frm_CheckBoxes_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_Period_KPICategory_Group_AP_Group_Performer'AND xtype = 'F')
ALTER TABLE [dbo].[AP_Group_Performer] ADD CONSTRAINT [FK_AP_Period_KPICategory_Group_AP_Group_Performer] FOREIGN KEY ([FGroupID]) REFERENCES [dbo].[AP_Period_KPICategory_Group] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_Training_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_Training] ADD CONSTRAINT [FK_REC_App_Training_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_GR_Budget_t_GR_FrameWork'AND xtype = 'F')
ALTER TABLE [dbo].[t_GR_Budget] ADD CONSTRAINT [FK_t_GR_Budget_t_GR_FrameWork] FOREIGN KEY ([FFrameworkID]) REFERENCES [dbo].[t_GR_FrameWork] ([FFrameWorkID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_GR_Budget_t_GR_StandAcct'AND xtype = 'F')
ALTER TABLE [dbo].[t_GR_Budget] ADD CONSTRAINT [FK_t_GR_Budget_t_GR_StandAcct] FOREIGN KEY ([FAccountID]) REFERENCES [dbo].[t_GR_StandAcct] ([FAccountID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlTables_Frm_HtmlContainerControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlTables] ADD CONSTRAINT [FK_Frm_HtmlTables_Frm_HtmlContainerControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlContainerControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_AttchInfo_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_AttchInfo] ADD CONSTRAINT [FK_REC_App_AttchInfo_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_FABalPurchase_t_FABalance'AND xtype = 'F')
ALTER TABLE [dbo].[t_FABalPurchase] ADD CONSTRAINT [FK_t_FABalPurchase_t_FABalance] FOREIGN KEY ([FBalID]) REFERENCES [dbo].[t_FABalance] ([FBalID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_ApplicantAccessory_HM_EM_Accessories'AND xtype = 'F')
ALTER TABLE [dbo].[REC_ApplicantAccessory] ADD CONSTRAINT [FK_REC_ApplicantAccessory_HM_EM_Accessories] FOREIGN KEY ([ID]) REFERENCES [dbo].[HM_EM_Accessories] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlInputTexts_Frm_HtmlInputControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlInputTexts] ADD CONSTRAINT [FK_Frm_HtmlInputTexts_Frm_HtmlInputControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlInputControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_GlAutoVchAcct_t_GlAutoCreateVch'AND xtype = 'F')
ALTER TABLE [dbo].[t_GlAutoVchAcct] ADD CONSTRAINT [FK_t_GlAutoVchAcct_t_GlAutoCreateVch] FOREIGN KEY ([FSchemeID]) REFERENCES [dbo].[t_GlAutoCreateVch] ([FSchemeID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_EduCourse_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_EduCourse] ADD CONSTRAINT [FK_REC_App_EduCourse_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlImages_Frm_HtmlControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlImages] ADD CONSTRAINT [FK_Frm_HtmlImages_Frm_HtmlControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_POS_REF_ORG_POSI'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_PositionAgent] ADD CONSTRAINT [FK_HRMS_POS_REF_ORG_POSI] FOREIGN KEY ([PositionID]) REFERENCES [dbo].[ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_PaperItem_HR_TR_ExamPaper'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_PaperItem] ADD CONSTRAINT [FK_HR_TR_PaperItem_HR_TR_ExamPaper] FOREIGN KEY ([PaperID]) REFERENCES [dbo].[HR_TR_ExamPaper] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_KPI_AP_Objective_Category'AND xtype = 'F')
ALTER TABLE [dbo].[AP_KPI] ADD CONSTRAINT [FK_AP_KPI_AP_Objective_Category] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[AP_Objective_Category] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_TableRows_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_TableRows] ADD CONSTRAINT [FK_Frm_TableRows_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_PDescriptionDutySet_ORG_PDescriptionDuty'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_PDescriptionDutySet] ADD CONSTRAINT [FK_ORG_PDescriptionDutySet_ORG_PDescriptionDuty] FOREIGN KEY ([DutyID]) REFERENCES [dbo].[ORG_PDescriptionDuty] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_PDescriptionDutySet_ORG_PositionDescription'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_PDescriptionDutySet] ADD CONSTRAINT [FK_ORG_PDescriptionDutySet_ORG_PositionDescription] FOREIGN KEY ([PositionDescriptionID]) REFERENCES [dbo].[ORG_PositionDescription] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_OfficeDrt_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_InterviewOpinion_OfficeDrt] ADD CONSTRAINT [FK_REC_InterviewOpinion_OfficeDrt_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_TR_REFERENCE_HR_TR_TR'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_TrainActivityAntiApprove] ADD CONSTRAINT [FK_HR_TR_TR_REFERENCE_HR_TR_TR] FOREIGN KEY ([TrainActivityID]) REFERENCES [dbo].[HR_TR_TrainActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_FLedgerID'AND xtype = 'F')
ALTER TABLE [dbo].[t_MultiColumn] ADD CONSTRAINT [FK_FLedgerID] FOREIGN KEY ([FLedgerID]) REFERENCES [dbo].[t_MultiColumnLedger] ([FLedgerID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_FAUserDeprRate_t_FADeprMethod'AND xtype = 'F')
ALTER TABLE [dbo].[t_FAUserDeprRate] ADD CONSTRAINT [FK_t_FAUserDeprRate_t_FADeprMethod] FOREIGN KEY ([FDeprMethodID]) REFERENCES [dbo].[t_FADeprMethod] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_MG_USERR_FK_MG_USE_MG_FUNCT'AND xtype = 'F')
ALTER TABLE [dbo].[MG_UserRight] ADD CONSTRAINT [FK_MG_USERR_FK_MG_USE_MG_FUNCT] FOREIGN KEY ([right_id]) REFERENCES [dbo].[MG_Functions] ([right_id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_USE_FK_HRMS_U_HRMS_US3'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_UserGroup_Members] ADD CONSTRAINT [FK_HRMS_USE_FK_HRMS_U_HRMS_US3] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[HRMS_UserGroups] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_ReqPosition_REC_ReqApplication'AND xtype = 'F')
ALTER TABLE [dbo].[REC_ReqPosition] ADD CONSTRAINT [FK_REC_ReqPosition_REC_ReqApplication] FOREIGN KEY ([ReqAppID]) REFERENCES [dbo].[REC_ReqApplication] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_SMS_S_REFERENCE_HR_SMS_S'AND xtype = 'F')
ALTER TABLE [dbo].[HR_SMS_SMSItemOption] ADD CONSTRAINT [FK_HR_SMS_S_REFERENCE_HR_SMS_S] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[HR_SMS_SMSQuenssiareItem] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ActivitySummary_HR_TR_TrainActivity'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivitySummary] ADD CONSTRAINT [FK_HR_TR_ActivitySummary_HR_TR_TrainActivity] FOREIGN KEY ([ActivityID]) REFERENCES [dbo].[HR_TR_TrainActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_RecruitPosition_REC_RecruitActivity'AND xtype = 'F')
ALTER TABLE [dbo].[REC_RecruitPosition] ADD CONSTRAINT [FK_REC_RecruitPosition_REC_RecruitActivity] FOREIGN KEY ([ActivityID]) REFERENCES [dbo].[REC_RecruitActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_TAB_FK_HRMS_T_HRMS_TAB'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_TableCategoryMembers] WITH NOCHECK ADD CONSTRAINT [FK_HRMS_TAB_FK_HRMS_T_HRMS_TAB] FOREIGN KEY ([TableID]) REFERENCES [dbo].[HRMS_Tables] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_EntStrategy_Item'AND xtype = 'F')
ALTER TABLE [dbo].[T_OM_EntStrategyItem] ADD CONSTRAINT [FK_EntStrategy_Item] FOREIGN KEY ([FEntStrategyID]) REFERENCES [dbo].[T_OM_EntStrategy] ([FEntStrategyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlTableCells_Frm_HtmlContainerControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlTableCells] ADD CONSTRAINT [FK_Frm_HtmlTableCells_Frm_HtmlContainerControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlContainerControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_BookBorrow_HR_TR_Book'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_BookBorrow] ADD CONSTRAINT [FK_HR_TR_BookBorrow_HR_TR_Book] FOREIGN KEY ([BookID]) REFERENCES [dbo].[HR_TR_Book] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Wf_serviceVariants_HRMS_Services'AND xtype = 'F')
ALTER TABLE [dbo].[Wf_serviceVariants] ADD CONSTRAINT [FK_Wf_serviceVariants_HRMS_Services] FOREIGN KEY ([ServiceId]) REFERENCES [dbo].[HRMS_Services] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_Book_HR_TR_BookCategory'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_Book] ADD CONSTRAINT [FK_HR_TR_Book_HR_TR_BookCategory] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[HR_TR_BookCategory] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_DPA_P_REFERENCE_HR_DPA_P'AND xtype = 'F')
ALTER TABLE [dbo].[HR_DPA_Payment] ADD CONSTRAINT [FK_HR_DPA_P_REFERENCE_HR_DPA_P] FOREIGN KEY ([FPeriodID]) REFERENCES [dbo].[HR_DPA_Period] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_CollectFormula_AP_CollectSolution'AND xtype = 'F')
ALTER TABLE [dbo].[AP_CollectFormula] ADD CONSTRAINT [FK_AP_CollectFormula_AP_CollectSolution] FOREIGN KEY ([CollectSolutionID]) REFERENCES [dbo].[AP_CollectSolution] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_Register_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_InterviewOpinion_Register] ADD CONSTRAINT [FK_REC_InterviewOpinion_Register_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_TAS_FK_HRMS_T_HRMS_TAS'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_Tasks] ADD CONSTRAINT [FK_HRMS_TAS_FK_HRMS_T_HRMS_TAS] FOREIGN KEY ([FolderID]) REFERENCES [dbo].[HRMS_TaskFolders] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_PaperExamReply_HR_TR_OnLineExam'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_PaperExamReply] ADD CONSTRAINT [FK_HR_TR_PaperExamReply_HR_TR_OnLineExam] FOREIGN KEY ([ExamID]) REFERENCES [dbo].[HR_TR_OnLineExam] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_Labels_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_Labels] ADD CONSTRAINT [FK_Frm_Labels_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_ITEM_REFERENCE_AP_ITEMT'AND xtype = 'F')
ALTER TABLE [dbo].[AP_Item] ADD CONSTRAINT [FK_AP_ITEM_REFERENCE_AP_ITEMT] FOREIGN KEY ([ItemTypeID]) REFERENCES [dbo].[AP_ItemType] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlTextAreas_Frm_HtmlContainerControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlTextAreas] ADD CONSTRAINT [FK_Frm_HtmlTextAreas_Frm_HtmlContainerControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlContainerControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_OnLineExam_HR_TR_ExamClass'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_OnLineExam] ADD CONSTRAINT [FK_HR_TR_OnLineExam_HR_TR_ExamClass] FOREIGN KEY ([ExamClassID]) REFERENCES [dbo].[HR_TR_ExamClass] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_OnLineExam_HR_TR_ExamPaperInstance1'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_OnLineExam] ADD CONSTRAINT [FK_HR_TR_OnLineExam_HR_TR_ExamPaperInstance1] FOREIGN KEY ([PaperInstanceID]) REFERENCES [dbo].[HR_TR_ExamPaperInstance] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_SysFunction_SubSystem'AND xtype = 'F')
ALTER TABLE [dbo].[t_SysFunction] ADD CONSTRAINT [FK_SysFunction_SubSystem] FOREIGN KEY ([FSubSysID]) REFERENCES [dbo].[t_SubSystem] ([FSubSysID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FCurrencyID'AND xtype = 'F')
ALTER TABLE [dbo].[ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FCurrencyID] FOREIGN KEY ([FCurrencyID]) REFERENCES [dbo].[t_Currency] ([FCurrencyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FDepartment'AND xtype = 'F')
ALTER TABLE [dbo].[ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FDepartment] FOREIGN KEY ([FDepartment]) REFERENCES [dbo].[t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FEmployee'AND xtype = 'F')
ALTER TABLE [dbo].[ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FEmployee] FOREIGN KEY ([FEmployee]) REFERENCES [dbo].[t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ICPurBill_FVendor'AND xtype = 'F')
ALTER TABLE [dbo].[ICPurBill] ADD CONSTRAINT [FK_ICPurBill_FVendor] FOREIGN KEY ([FVendor]) REFERENCES [dbo].[t_Item] ([FItemID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_PrjExperience_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_PrjExperience] ADD CONSTRAINT [FK_REC_App_PrjExperience_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_DPA_T_REFERENCE_HR_DPA_P'AND xtype = 'F')
ALTER TABLE [dbo].[HR_DPA_ToPaPeriod] ADD CONSTRAINT [FK_HR_DPA_T_REFERENCE_HR_DPA_P] FOREIGN KEY ([FPeriodID]) REFERENCES [dbo].[HR_DPA_Period] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgMultiCheckLevel_FBillType'AND xtype = 'F')
ALTER TABLE [dbo].[t_MgMultiCheckLevel] ADD CONSTRAINT [FK_t_MgMultiCheckLevel_FBillType] FOREIGN KEY ([FBillType]) REFERENCES [dbo].[t_MgMultiCheckOption] ([FBillType])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_WorkCourse_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_WorkCourse] ADD CONSTRAINT [FK_REC_App_WorkCourse_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HM_EM_RE_FK_HM_EM__HM_EM_RE'AND xtype = 'F')
ALTER TABLE [dbo].[HM_Em_Relation_Targets] ADD CONSTRAINT [FK_HM_EM_RE_FK_HM_EM__HM_EM_RE] FOREIGN KEY ([EmRelationID]) REFERENCES [dbo].[HM_Em_Relations] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_ReqRecruitNotice_REC_ReqRecruit'AND xtype = 'F')
ALTER TABLE [dbo].[REC_ReqRecruitNotice] ADD CONSTRAINT [FK_REC_ReqRecruitNotice_REC_ReqRecruit] FOREIGN KEY ([ReqRecruitID]) REFERENCES [dbo].[REC_ReqRecruit] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_dls_TableStruct_t_dls_TableList'AND xtype = 'F')
ALTER TABLE [dbo].[t_dls_TableStruct] ADD CONSTRAINT [FK_t_dls_TableStruct_t_dls_TableList] FOREIGN KEY ([tablename]) REFERENCES [dbo].[t_dls_TableList] ([tablename])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRIndex_Recipient_HRIndex_MailSettingScheme'AND xtype = 'F')
ALTER TABLE [dbo].[HRIndex_Recipient] ADD CONSTRAINT [FK_HRIndex_Recipient_HRIndex_MailSettingScheme] FOREIGN KEY ([MailSettingID]) REFERENCES [dbo].[HRIndex_MailSettingScheme] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_FABalCardItem_t_FABalance'AND xtype = 'F')
ALTER TABLE [dbo].[t_FABalCardItem] ADD CONSTRAINT [FK_t_FABalCardItem_t_FABalance] FOREIGN KEY ([FBalID]) REFERENCES [dbo].[t_FABalance] ([FBalID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_WF_Operate_T_WF_BusinessObject'AND xtype = 'F')
ALTER TABLE [dbo].[T_WF_Operate] ADD CONSTRAINT [FK_T_WF_Operate_T_WF_BusinessObject] FOREIGN KEY ([FBusinessObjectID]) REFERENCES [dbo].[T_WF_BusinessObject] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_BuzObj_BuzType'AND xtype = 'F')
ALTER TABLE [dbo].[T_WF_BusinessObject] ADD CONSTRAINT [FK_BuzObj_BuzType] FOREIGN KEY ([FBusinessTypeID]) REFERENCES [dbo].[T_WF_BusinessType] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_QuestionnaireItem_HR_TR_Questionnaire'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_QuestionnaireItem] ADD CONSTRAINT [FK_HR_TR_QuestionnaireItem_HR_TR_Questionnaire] FOREIGN KEY ([QnID]) REFERENCES [dbo].[HR_TR_Questionnaire] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_GR_InvestInfo_t_GR_FrameWork'AND xtype = 'F')
ALTER TABLE [dbo].[t_GR_InvestInfo] ADD CONSTRAINT [FK_t_GR_InvestInfo_t_GR_FrameWork] FOREIGN KEY ([FFrameworkID]) REFERENCES [dbo].[t_GR_FrameWork] ([FFrameWorkID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_MS_Previse_Recipients_MS_Previse'AND xtype = 'F')
ALTER TABLE [dbo].[MS_Previse_Recipients] ADD CONSTRAINT [FK_MS_Previse_Recipients_MS_Previse] FOREIGN KEY ([PreviseID]) REFERENCES [dbo].[MS_Previse] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_CheckBoxLists_Frm_ListControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_CheckBoxLists] ADD CONSTRAINT [FK_Frm_CheckBoxLists_Frm_ListControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_ListControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlSelects_Frm_HtmlContainerControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlSelects] ADD CONSTRAINT [FK_Frm_HtmlSelects_Frm_HtmlContainerControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlContainerControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_HRPlanPosition_REC_HRPlan'AND xtype = 'F')
ALTER TABLE [dbo].[REC_HRPlanPosition] ADD CONSTRAINT [FK_REC_HRPlanPosition_REC_HRPlan] FOREIGN KEY ([HRPlanID]) REFERENCES [dbo].[REC_HRPlan] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_PL_SP_FK_HR_PL__HR_PL_SA'AND xtype = 'F')
ALTER TABLE [dbo].[HR_PL_SPointItemData] ADD CONSTRAINT [FK_HR_PL_SP_FK_HR_PL__HR_PL_SA] FOREIGN KEY ([FSPItemID]) REFERENCES [dbo].[HR_PL_SalaryPointItem] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'fk_t_qy_UserPrimaryGroup'AND xtype = 'F')
ALTER TABLE [dbo].[t_qy_User] ADD CONSTRAINT [fk_t_qy_UserPrimaryGroup] FOREIGN KEY ([FPrimaryGroup]) REFERENCES [dbo].[t_qy_User] ([FUserID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_K3ForNet_FrameworkItem_t_K3ForNet_FrameWork'AND xtype = 'F')
ALTER TABLE [dbo].[t_K3ForNet_FrameworkItem] ADD CONSTRAINT [FK_t_K3ForNet_FrameworkItem_t_K3ForNet_FrameWork] FOREIGN KEY ([FFrameworkID]) REFERENCES [dbo].[t_K3ForNet_FrameWork] ([FFrameWorkID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_JOBG_FK_ORG_JO_ORG_JOB'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_JobGradeSet] ADD CONSTRAINT [FK_ORG_JOBG_FK_ORG_JO_ORG_JOB] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ORG_Job] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_JOBG_FK_ORG_JO_ORG_JOBG'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_JobGradeSet] ADD CONSTRAINT [FK_ORG_JOBG_FK_ORG_JO_ORG_JOBG] FOREIGN KEY ([GradeID]) REFERENCES [dbo].[ORG_JobGrade] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_PA_taxPamaRef1'AND xtype = 'F')
ALTER TABLE [dbo].[t_PA_taxpamaRef] ADD CONSTRAINT [FK_PA_taxPamaRef1] FOREIGN KEY ([FTaxID]) REFERENCES [dbo].[t_PA_taxpama] ([FTaxID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_FormItemActivities_Frm_FormItems'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_FormItemActivities] ADD CONSTRAINT [FK_Frm_FormItemActivities_Frm_FormItems] FOREIGN KEY ([FormItemId]) REFERENCES [dbo].[Frm_FormItems] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_POS_REF_HRMS_PER'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_PositionRight_Range] ADD CONSTRAINT [FK_HRMS_POS_REF_HRMS_PER] FOREIGN KEY ([RightID]) REFERENCES [dbo].[HRMS_Permissions] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_MYK3_F_REF_24_T_MYK3_F'AND xtype = 'F')
ALTER TABLE [dbo].[t_MyK3_FunctionsInfo_Child] ADD CONSTRAINT [FK_T_MYK3_F_REF_24_T_MYK3_F] FOREIGN KEY ([FFunctionID]) REFERENCES [dbo].[t_MyK3_FunctionsInfo] ([FFunctionID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_QuestionnaireItemReply_HR_TR_QuestionnaireInstance'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_QuestionnaireItemReply] ADD CONSTRAINT [FK_HR_TR_QuestionnaireItemReply_HR_TR_QuestionnaireInstance] FOREIGN KEY ([QInstanceID]) REFERENCES [dbo].[HR_TR_QuestionnaireInstance] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ActivityExam_HR_TR_ExamPaper'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityExam] ADD CONSTRAINT [FK_HR_TR_ActivityExam_HR_TR_ExamPaper] FOREIGN KEY ([ExamPaperID]) REFERENCES [dbo].[HR_TR_ExamPaper] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ActivityExam_HR_TR_TrainActivity'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityExam] ADD CONSTRAINT [FK_HR_TR_ActivityExam_HR_TR_TrainActivity] FOREIGN KEY ([ActivityID]) REFERENCES [dbo].[HR_TR_TrainActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_PL_SAL_REFERENCE_HR_PL_SAL'AND xtype = 'F')
ALTER TABLE [dbo].[HR_PL_SalaryLayout_DefAmount] ADD CONSTRAINT [FK_HR_PL_SAL_REFERENCE_HR_PL_SAL] FOREIGN KEY ([FID]) REFERENCES [dbo].[HR_PL_SalaryLayout_DefProp] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_NoticeProcess_HR_TR_TrainNotice'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_NoticeProcess] ADD CONSTRAINT [FK_HR_TR_NoticeProcess_HR_TR_TrainNotice] FOREIGN KEY ([NoticeID]) REFERENCES [dbo].[HR_TR_TrainNotice] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_PDescriptionDuty_ORG_PositionDescription'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_PDescriptionDuty] ADD CONSTRAINT [FK_ORG_PDescriptionDuty_ORG_PositionDescription] FOREIGN KEY ([PositionDescriptionID]) REFERENCES [dbo].[ORG_PositionDescription] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_EVE_FK_HRMS_E_HRMS_EVE'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_EventLogEntries] ADD CONSTRAINT [FK_HRMS_EVE_FK_HRMS_E_HRMS_EVE] FOREIGN KEY ([EventLogID]) REFERENCES [dbo].[HRMS_EventLogs] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_JobWill_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_JobWill] ADD CONSTRAINT [FK_REC_App_JobWill_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_UserDept_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_InterviewOpinion_UserDept] ADD CONSTRAINT [FK_REC_InterviewOpinion_UserDept_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ClassMaterial_HR_TR_TrainClass'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ClassMaterial] ADD CONSTRAINT [FK_HR_TR_ClassMaterial_HR_TR_TrainClass] FOREIGN KEY ([ClassID]) REFERENCES [dbo].[HR_TR_TrainClass] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ClassMaterial_HR_TR_TrainMaterial'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ClassMaterial] ADD CONSTRAINT [FK_HR_TR_ClassMaterial_HR_TR_TrainMaterial] FOREIGN KEY ([MaterialID]) REFERENCES [dbo].[HR_TR_TrainMaterial] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_HRDept_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_InterviewOpinion_HRDept] ADD CONSTRAINT [FK_REC_InterviewOpinion_HRDept_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_InterviewOpinion_RelateDept_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_InterviewOpinion_RelateDept] ADD CONSTRAINT [FK_REC_InterviewOpinion_RelateDept_REC_BaseInfo] FOREIGN KEY ([FApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_TableCells_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_TableCells] ADD CONSTRAINT [FK_Frm_TableCells_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_Images_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_Images] ADD CONSTRAINT [FK_Frm_Images_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HM_EM_RE_FK_HM_EM__ORG_POS2'AND xtype = 'F')
ALTER TABLE [dbo].[HM_EM_Redeploy] ADD CONSTRAINT [FK_HM_EM_RE_FK_HM_EM__ORG_POS2] FOREIGN KEY ([OldPositionID]) REFERENCES [dbo].[ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HM_EM_RE_FK_HM_EM__ORG_POSI'AND xtype = 'F')
ALTER TABLE [dbo].[HM_EM_Redeploy] ADD CONSTRAINT [FK_HM_EM_RE_FK_HM_EM__ORG_POSI] FOREIGN KEY ([NewPositionID]) REFERENCES [dbo].[ORG_Position] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_QU_REFERENCE_HR_TR_QU'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_QuestionEmpReply] ADD CONSTRAINT [FK_HR_TR_QU_REFERENCE_HR_TR_QU] FOREIGN KEY ([QnLogID]) REFERENCES [dbo].[HR_TR_QuestionnaireLog] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_QuestionnaireLog_HR_TR_QuestionnaireInstance'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_QuestionnaireLog] ADD CONSTRAINT [FK_HR_TR_QuestionnaireLog_HR_TR_QuestionnaireInstance] FOREIGN KEY ([QInstanceID]) REFERENCES [dbo].[HR_TR_QuestionnaireInstance] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_RIG_REF_HRMS_2'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_RightGroup_Right] ADD CONSTRAINT [FK_HRMS_RIG_REF_HRMS_2] FOREIGN KEY ([RightID]) REFERENCES [dbo].[HRMS_Permissions] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_RIG_REF_HRMS_R1'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_RightGroup_Right] ADD CONSTRAINT [FK_HRMS_RIG_REF_HRMS_R1] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[HRMS_RightGroup] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_FAPurchase_t_FAAlter'AND xtype = 'F')
ALTER TABLE [dbo].[t_FAPurchase] ADD CONSTRAINT [FK_t_FAPurchase_t_FAAlter] FOREIGN KEY ([FAlterID]) REFERENCES [dbo].[t_FAAlter] ([FAlterID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_TextBoxes_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_TextBoxes] ADD CONSTRAINT [FK_Frm_TextBoxes_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_ListItems_Frm_ListControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_ListItems] ADD CONSTRAINT [FK_Frm_ListItems_Frm_ListControls] FOREIGN KEY ([ListControlId]) REFERENCES [dbo].[Frm_ListControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_ListControls_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_ListControls] ADD CONSTRAINT [FK_Frm_ListControls_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBudVchHook_FBillID'AND xtype = 'F')
ALTER TABLE [dbo].[t_MgBudVchHook] ADD CONSTRAINT [FK_t_MgBudVchHook_FBillID] FOREIGN KEY ([FBillID]) REFERENCES [dbo].[t_MgBill] ([FBillID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_FIE_FK_HRMS_F_HRMS_FI2'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_FieldCategoryMembers] ADD CONSTRAINT [FK_HRMS_FIE_FK_HRMS_F_HRMS_FI2] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[HRMS_FieldCategories] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_FIE_FK_HRMS_F_HRMS_FI3'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_FieldCategoryMembers] ADD CONSTRAINT [FK_HRMS_FIE_FK_HRMS_F_HRMS_FI3] FOREIGN KEY ([FieldID]) REFERENCES [dbo].[HRMS_Fields] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_AC_REFERENCE_HR_TR_QU'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityQuestionnaire] ADD CONSTRAINT [FK_HR_TR_AC_REFERENCE_HR_TR_QU] FOREIGN KEY ([QnInstanceID]) REFERENCES [dbo].[HR_TR_QuestionnaireInstance] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ActivityQuestionnaire_HR_TR_Questionnaire'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityQuestionnaire] ADD CONSTRAINT [FK_HR_TR_ActivityQuestionnaire_HR_TR_Questionnaire] FOREIGN KEY ([QuestionnaireID]) REFERENCES [dbo].[HR_TR_Questionnaire] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ActivityQuestionnaire_HR_TR_TrainActivity'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityQuestionnaire] ADD CONSTRAINT [FK_HR_TR_ActivityQuestionnaire_HR_TR_TrainActivity] FOREIGN KEY ([ActivityID]) REFERENCES [dbo].[HR_TR_TrainActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_QuestionnaireInstance_HR_TR_Questionnaire'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_QuestionnaireInstance] ADD CONSTRAINT [FK_HR_TR_QuestionnaireInstance_HR_TR_Questionnaire] FOREIGN KEY ([QnID]) REFERENCES [dbo].[HR_TR_Questionnaire] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_GR_CurrentAccountlog_t_GR_FrameWork'AND xtype = 'F')
ALTER TABLE [dbo].[t_GR_CurrentAccountlog] ADD CONSTRAINT [FK_t_GR_CurrentAccountlog_t_GR_FrameWork] FOREIGN KEY ([FFrameworkID]) REFERENCES [dbo].[t_GR_FrameWork] ([FFrameWorkID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_FamilyRelation_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_FamilyRelation] ADD CONSTRAINT [FK_REC_App_FamilyRelation_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HtmlTableRows_Frm_HtmlContainerControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HtmlTableRows] ADD CONSTRAINT [FK_Frm_HtmlTableRows_Frm_HtmlContainerControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_HtmlContainerControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_MS_Previse_Recipients_certificateClass'AND xtype = 'F')
ALTER TABLE [dbo].[MS_Previse_certificateClass] ADD CONSTRAINT [FK_MS_Previse_Recipients_certificateClass] FOREIGN KEY ([PreviseID]) REFERENCES [dbo].[MS_Previse] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_Frm_HyperLinks_Frm_WebControls'AND xtype = 'F')
ALTER TABLE [dbo].[Frm_HyperLinks] ADD CONSTRAINT [FK_Frm_HyperLinks_Frm_WebControls] FOREIGN KEY ([Id]) REFERENCES [dbo].[Frm_WebControls] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_ViewsFieldForPayroll_t_ViewsForPayroll'AND xtype = 'F')
ALTER TABLE [dbo].[t_ViewsFieldForPayroll] WITH NOCHECK ADD CONSTRAINT [FK_t_ViewsFieldForPayroll_t_ViewsForPayroll] FOREIGN KEY ([ViewID]) REFERENCES [dbo].[t_ViewsForPayroll] ([ID]) NOT FOR REPLICATION
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_ViewsForPayroll_t_ViewsTypeForPayroll'AND xtype = 'F')
ALTER TABLE [dbo].[t_ViewsForPayroll] WITH NOCHECK ADD CONSTRAINT [FK_t_ViewsForPayroll_t_ViewsTypeForPayroll] FOREIGN KEY ([Type]) REFERENCES [dbo].[t_ViewsTypeForPayroll] ([ID]) NOT FOR REPLICATION
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_ServiceDatas_Detail_HRMS_ServiceDatas_Main'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_ServiceDatas_Detail] ADD CONSTRAINT [FK_HRMS_ServiceDatas_Detail_HRMS_ServiceDatas_Main] FOREIGN KEY ([MainDataId]) REFERENCES [dbo].[HRMS_ServiceDatas_Main] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HRMS_ServiceDatas_Main_Wf_ProcessInstances'AND xtype = 'F')
ALTER TABLE [dbo].[HRMS_ServiceDatas_Main] ADD CONSTRAINT [FK_HRMS_ServiceDatas_Main_Wf_ProcessInstances] FOREIGN KEY ([ProcInstId]) REFERENCES [dbo].[Wf_ProcessInstances] ([Id])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_REC_App_BaseInfoAttch_REC_BaseInfo'AND xtype = 'F')
ALTER TABLE [dbo].[REC_App_BaseInfoAttch] ADD CONSTRAINT [FK_REC_App_BaseInfoAttch_REC_BaseInfo] FOREIGN KEY ([ApplicantID]) REFERENCES [dbo].[REC_BaseInfo] ([ApplicantID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_JOBS_FK_ORG_JO_ORG_JOB'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_JobSkill] ADD CONSTRAINT [FK_ORG_JOBS_FK_ORG_JO_ORG_JOB] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ORG_Job] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_JOBS_FK_ORG_JO_ORG_SKIL'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_JobSkill] ADD CONSTRAINT [FK_ORG_JOBS_FK_ORG_JO_ORG_SKIL] FOREIGN KEY ([SkillID]) REFERENCES [dbo].[ORG_Skill] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_ORG_SKIL_FK_ORG_SK_ORG_SKIL'AND xtype = 'F')
ALTER TABLE [dbo].[ORG_Skill] ADD CONSTRAINT [FK_ORG_SKIL_FK_ORG_SK_ORG_SKIL] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[ORG_SkillCategory] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_ActivityClass_HR_TR_TrainActivity'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_TrainActivityClass] ADD CONSTRAINT [FK_HR_TR_ActivityClass_HR_TR_TrainActivity] FOREIGN KEY ([ActivityID]) REFERENCES [dbo].[HR_TR_TrainActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_TrainActivityClass_HR_TR_TrainClass'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_TrainActivityClass] ADD CONSTRAINT [FK_HR_TR_TrainActivityClass_HR_TR_TrainClass] FOREIGN KEY ([ClassID]) REFERENCES [dbo].[HR_TR_TrainClass] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_T_KDS_RE_REF_38_T_KDS_RE'AND xtype = 'F')
ALTER TABLE [dbo].[t_Kds_ReportClass] ADD CONSTRAINT [FK_T_KDS_RE_REF_38_T_KDS_RE] FOREIGN KEY ([FParentClassID]) REFERENCES [dbo].[t_Kds_ReportClass] ([FReportClassID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_AttachmentFile_HR_TR_TrainMaterial'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_AttachmentFile] ADD CONSTRAINT [FK_HR_TR_AttachmentFile_HR_TR_TrainMaterial] FOREIGN KEY ([MaterialID]) REFERENCES [dbo].[HR_TR_TrainMaterial] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_t_MgBudModifyDetail_FModifyID'AND xtype = 'F')
ALTER TABLE [dbo].[t_MgBudModifyDetail] ADD CONSTRAINT [FK_t_MgBudModifyDetail_FModifyID] FOREIGN KEY ([FModifyID]) REFERENCES [dbo].[t_MgBudgetModify] ([FModifyID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_AC_REFERENCE_HR_TR_CO'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityExamStyle] ADD CONSTRAINT [FK_HR_TR_AC_REFERENCE_HR_TR_CO] FOREIGN KEY ([FExamStyle]) REFERENCES [dbo].[HR_TR_Code_ExamStyle] ([FID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_AC_REFERENCE_HR_TR_TR'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_ActivityExamStyle] ADD CONSTRAINT [FK_HR_TR_AC_REFERENCE_HR_TR_TR] FOREIGN KEY ([FActivityID]) REFERENCES [dbo].[HR_TR_TrainActivity] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_HR_TR_RequirementClass_HR_TR_TrainClass'AND xtype = 'F')
ALTER TABLE [dbo].[HR_TR_RequirementClass] ADD CONSTRAINT [FK_HR_TR_RequirementClass_HR_TR_TrainClass] FOREIGN KEY ([ClassID]) REFERENCES [dbo].[HR_TR_TrainClass] ([ID])
IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE name = 'FK_AP_Period_K

产品问题WISE迁移最新工具(2018-05-15)迁移失败?

产品问题 WISE迁移最新工具(2018-05-15)迁移失败?

恭喜您！

产品问题
WISE迁移最新工具(2018-05-15)迁移失败?