Has anyone run into this problem with invalid column name in APInvDtl Invalid column name ‘BudTotLbrHrs’?
Epicor Version form 10.2.300.33 to 11.1.200.
Error:
Log File Location: C:\Program Files (x86)\Common Files\Epicor Software\Database Manager Extensions\4.1.200\DB Migration\Epicor11_Results_03_31_2022 15_31_25.txt
Starting Preparation
- BPM Customization purger
Preparation Complete: 0.0030785 seconds
Starting Execution Phase…
- BPM Customization purger
Information BPM Customization purger BPM Customization purger~ Purge process started
Information BPM Customization purger BPM Customization purger~ Customization ‘BPM.BO’ purged for:
Information BPM Customization purger BPM Customization purger~ Customization ‘BPM.DT’ purged for:
Information BPM Customization purger BPM Customization purger~ Customization binaries in ‘BO’ folder purged for:
Information BPM Customization purger BPM Customization purger~ Customization binaries in ‘DT’ folder purged for:
Information BPM Customization purger BPM Customization purger~ Purge process finished with success
Execute Phase Complete: 0.0663142 seconds
Starting Cleanup Phase…
- BPM Customization purger
Cleanup Phase: 0.0005857 seconds
Starting Preparation
- Ice.Internal.Upgrade.ReportDataDefinition
Preparation Complete: 0.0007634 seconds
Starting Execution Phase…
- Ice.Internal.Upgrade.ReportDataDefinition
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Upgrading customized Report Data Definitions
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptTable records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptTable Records Affected: 0
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptRelation records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptRelation Records Affected: 0
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptRelationField records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptRelationField Records Affected: 0
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptCalcField records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptCalcField Records Affected: 0
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptLinkTable records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptLinkTable Records Affected: 0
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptLinkField records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptLinkField Records Affected: 0
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptExclude records…
Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptExclude Records Affected: 0
Execute Phase Complete: 1.6922721 seconds
Starting Cleanup Phase…
- Ice.Internal.Upgrade.ReportDataDefinition
Cleanup Phase: 0.0010958 seconds
Starting Preparation
- SSRS Breaking/Routing Rules
Preparation Complete: 0.0008212 seconds
Starting Execution Phase…
- SSRS Breaking/Routing Rules
Information SSRS Breaking/Routing Rules SSRS Breaking/Routing Rules~ Starting upgrade for SSRS Breaking/Routing rules.
Information SSRS Breaking/Routing Rules SSRS Breaking/Routing Rules~ Upgrade for SSRS Breaking/Routing rules completed successfully.
Execute Phase Complete: 0.0075931 seconds
Starting Cleanup Phase…
- SSRS Breaking/Routing Rules
Cleanup Phase: 0.0142659 seconds
Starting Preparation
- Post Migration
Preparation Complete: 0.0037738 seconds
Starting Execution Phase…
- Post Migration
Information Post Migration Post Migration ~ Executing: ICE_ExtendedEvents.sql
Information Post Migration Post Migration ~ Executing: BackupXXXDefXXXChunk.sql
Information Post Migration Post Migration ~ Executing: CleanupCacheAndAssemblyStore.sql
Information Post Migration Post Migration ~ Executing: CleanupSessionState.sql
Information Post Migration Post Migration ~ Executing: DeleteFromSysTask.sql
Information Post Migration Post Migration ~ Executing: DropCleanupCaptureLogSQLJob.sql
Information Post Migration Post Migration ~ Executing: InsertZDataFieldwithUD.sql
Information Post Migration Post Migration ~ Executing: SeedBpDirectiveType.sql
Information Post Migration Post Migration ~ Executing: Set_IDENTITY_INSERT_OFF.sql
Information Post Migration Post Migration ~ Executing: SyncUDRows.sql
Information Post Migration Post Migration ~ Executing: UpdateBAQReportMenu.sql
Information Post Migration Post Migration ~ Executing: UpdateBpHoldSeq.sql
Information Post Migration Post Migration ~ Executing: UpdateMenu.sql
Information Post Migration Post Migration ~ Executing: UpdateRptTablesForCompany.sql
Information Post Migration Post Migration ~ Executing: UpdateZDataTableSchemaName.sql
Information Post Migration Post Migration ~ Executing: AddMissingMESMenuID.sql
Information Post Migration Post Migration ~ Executing: ClearExternalFileVersion.sql
Information Post Migration Post Migration ~ Executing: Create Effective Rates GLControl.sql
Information Post Migration Post Migration ~ Executing: DeleteBadWErrorRows.sql
Information Post Migration Post Migration ~ Executing: DeleteEFTHead.sql
Information Post Migration Post Migration ~ Executing: Insert_ERP_SysSequence.sql
Information Post Migration Post Migration ~ Executing: Insert_Ice_SysBigSequence.sql
Information Post Migration Post Migration ~ Executing: InsertIntoCompanySequence.sql
Information Post Migration Post Migration ~ Executing: MigrateRecurringInvoices.sql
Information Post Migration Post Migration ~ Executing: PopulateTaxTranSequences.sql
Information Post Migration Post Migration ~ Executing: SetBRFunction201.sql
Information Post Migration Post Migration ~ Executing: UpdateEFTHead.sql
Information Post Migration Post Migration ~ Executing: UpdateZDataTableForPartLot.sql
Information Post Migration Post Migration ~ Executing: DropICEObjects.sql
Information Post Migration Post Migration ~ Executing: DropERPObjects.sql
Information Post Migration Post Migration ~ Executing: DropEcfObjects.sql
Information Post Migration Post Migration ~ Executing: ICE_FKs.sql
Information Post Migration Post Migration ~ Executing: Ecf_FKs.sql
Information Post Migration Post Migration ~ Executing: ERP_FKs.sql
Information Post Migration Post Migration ~ Executing: DeleteDupRptRelationField.sql
Information Post Migration Post Migration ~ Executing: DeleteEmptyDataTableID.sql
Information Post Migration Post Migration ~ Executing: DeleteInvalidLocalization.sql
Information Post Migration Post Migration ~ Executing: DeleteInvalidPatchFld.sql
Information Post Migration Post Migration ~ Executing: DeleteQueryDuplicates.sql
Information Post Migration Post Migration ~ Executing: DropDBOBackupTables.sql
Information Post Migration Post Migration ~ Executing: DropSysRowIDFromUD.sql
Information Post Migration Post Migration ~ Executing: Set_PAGE_LOCKS_OFF.sql
Information Post Migration Post Migration ~ Executing: SyncUDRows.sql
Information Post Migration Post Migration ~ Executing: SyncUDSchemaToZData.sql
Information Post Migration Post Migration ~ Executing: UpdateBitFlag.sql
Information Post Migration Post Migration ~ Executing: zCallSPCreateTriggerForUDCreateView.sql
Error Post Migration zCallSPCreateTriggerForUDCreateView.sql Invalid column name ‘BudTotLbrHrs’.
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘APInvDtl’
ZDBCreateChangeCaptureTrigger for UD Table =APInvDtl_UD
ALTER TABLE [Erp].[APInvDtl_UD] DISABLE TRIGGER TR_APInvDtl_UD_ChangeCapture
ALTER TABLE [Erp].[APInvDtl_UD] WITH CHECK ADD CONSTRAINT FK_APInvDtl_UD_APInvDtl FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].APInvDtl
ON DELETE CASCADE
ALTER TABLE [Erp].[APInvDtl_UD] CHECK CONSTRAINT FK_APInvDtl_UD_APInvDtl
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘APInvDtl’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[APInvDtl] AS
SELECT a., b. FROM [Erp].[APInvDtl] a
LEFT OUTER JOIN [Erp].[APInvDtl_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.APInvDtl’
EXEC [Ice].[SPCreateUDForIM] Erp,APInvDtl
EXEC Ice.DropColumn ‘IM’, ‘IMAPInvDtl’, ‘SalesOrder_c’,1
ALTER TABLE [IM].[IMAPInvDtl] ALTER COLUMN SalesOrder_c int NOT NULL
ALTER TABLE [IM].[IMAPInvDtl] ADD CONSTRAINT [DF_IMAPInvDtl_SalesOrder_c] DEFAULT ((0)) FOR SalesOrder_c
EXEC Ice.DropColumn ‘IM’, ‘IMAPInvDtl’, ‘JobNum_c’,1
ALTER TABLE [IM].[IMAPInvDtl] ALTER COLUMN JobNum_c nvarchar(8) NOT NULL
ALTER TABLE [IM].[IMAPInvDtl] ADD CONSTRAINT [DF_IMAPInvDtl_JobNum_c] DEFAULT (’’) FOR JobNum_c
EXEC Ice.DropColumn ‘IM’, ‘IMAPInvDtl’, ‘Job2_c’,1
ALTER TABLE [IM].[IMAPInvDtl] ALTER COLUMN Job2_c int NOT NULL
ALTER TABLE [IM].[IMAPInvDtl] ADD CONSTRAINT [DF_IMAPInvDtl_Job2_c] DEFAULT ((0)) FOR Job2_c
EXEC Ice.DropColumn ‘IM’, ‘IMAPInvDtl’, ‘Job3_c’,1
ALTER TABLE [IM].[IMAPInvDtl] ALTER COLUMN Job3_c int NOT NULL
ALTER TABLE [IM].[IMAPInvDtl] ADD CONSTRAINT [DF_IMAPInvDtl_Job3_c] DEFAULT ((0)) FOR Job3_c
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘Customer’
ZDBCreateChangeCaptureTrigger for UD Table =Customer_UD
ALTER TABLE [Erp].[Customer_UD] DISABLE TRIGGER TR_Customer_UD_ChangeCapture
ALTER TABLE [Erp].[Customer_UD] WITH CHECK ADD CONSTRAINT FK_Customer_UD_Customer FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].Customer
ON DELETE CASCADE
ALTER TABLE [Erp].[Customer_UD] CHECK CONSTRAINT FK_Customer_UD_Customer
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘Customer’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[Customer] AS
SELECT a., b. FROM [Erp].[Customer] a
LEFT OUTER JOIN [Erp].[Customer_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.Customer’
EXEC [Ice].[SPCreateUDForIM] Erp,Customer
EXEC Ice.DropColumn ‘IM’, ‘IMCustomer’, ‘Builder_c’,1
ALTER TABLE [IM].[IMCustomer] ALTER COLUMN Builder_c bit NOT NULL
ALTER TABLE [IM].[IMCustomer] ADD CONSTRAINT [DF_IMCustomer_Builder_c] DEFAULT ((0)) FOR Builder_c
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘InvcHead’
ZDBCreateChangeCaptureTrigger for UD Table =InvcHead_UD
ALTER TABLE [Erp].[InvcHead_UD] DISABLE TRIGGER TR_InvcHead_UD_ChangeCapture
ALTER TABLE [Erp].[InvcHead_UD] WITH CHECK ADD CONSTRAINT FK_InvcHead_UD_InvcHead FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].InvcHead
ON DELETE CASCADE
ALTER TABLE [Erp].[InvcHead_UD] CHECK CONSTRAINT FK_InvcHead_UD_InvcHead
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘InvcHead’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[InvcHead] AS
SELECT a., b. FROM [Erp].[InvcHead] a
LEFT OUTER JOIN [Erp].[InvcHead_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.InvcHead’
EXEC [Ice].[SPCreateUDForIM] Erp,InvcHead
EXEC Ice.DropColumn ‘IM’, ‘IMInvcHead’, ‘Ar_Old_Invc_c’,1
ALTER TABLE [IM].[IMInvcHead] ALTER COLUMN Ar_Old_Invc_c nvarchar(50) NOT NULL
ALTER TABLE [IM].[IMInvcHead] ADD CONSTRAINT [DF_IMInvcHead_Ar_Old_Invc_c] DEFAULT (’’) FOR Ar_Old_Invc_c
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Ice’, ‘Menu’
ZDBCreateChangeCaptureTrigger for UD Table =Menu_UD
ALTER TABLE [Ice].[Menu_UD] DISABLE TRIGGER TR_Menu_UD_ChangeCapture
ALTER TABLE [Ice].[Menu_UD] WITH CHECK ADD CONSTRAINT FK_Menu_UD_Menu FOREIGN KEY([ForeignSysRowID])
REFERENCES [Ice].Menu
ON DELETE CASCADE
ALTER TABLE [Ice].[Menu_UD] CHECK CONSTRAINT FK_Menu_UD_Menu
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘Menu’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[Menu] AS
SELECT a., b. FROM [Ice].[Menu] a
LEFT OUTER JOIN [Ice].[Menu_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.Menu’
EXEC [Ice].[SPCreateUDForIM] Ice,Menu
EXEC Ice.DropColumn ‘IM’, ‘IMMenu’, ‘ShortChar01’,1
ALTER TABLE [IM].[IMMenu] ALTER COLUMN ShortChar01 nvarchar(50) NOT NULL
ALTER TABLE [IM].[IMMenu] ADD CONSTRAINT [DF_IMMenu_ShortChar01] DEFAULT (’’) FOR ShortChar01
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘OrderDtl’
ZDBCreateChangeCaptureTrigger for UD Table =OrderDtl_UD
ALTER TABLE [Erp].[OrderDtl_UD] DISABLE TRIGGER TR_OrderDtl_UD_ChangeCapture
ALTER TABLE [Erp].[OrderDtl_UD] WITH CHECK ADD CONSTRAINT FK_OrderDtl_UD_OrderDtl FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].OrderDtl
ON DELETE CASCADE
ALTER TABLE [Erp].[OrderDtl_UD] CHECK CONSTRAINT FK_OrderDtl_UD_OrderDtl
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘OrderDtl’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[OrderDtl] AS
SELECT a., b. FROM [Erp].[OrderDtl] a
LEFT OUTER JOIN [Erp].[OrderDtl_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.OrderDtl’
EXEC [Ice].[SPCreateUDForIM] Erp,OrderDtl
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Status_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Status_c nvarchar(50) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Status_c] DEFAULT (’’) FOR Status_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Total_Load_ToNoLo_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Total_Load_ToNoLo_c int NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Total_Load_ToNoLo_c] DEFAULT ((0)) FOR Total_Load_ToNoLo_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Total_Wt_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Total_Wt_c int NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Total_Wt_c] DEFAULT ((0)) FOR Total_Wt_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘TotalShipWt_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN TotalShipWt_c int NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_TotalShipWt_c] DEFAULT ((0)) FOR TotalShipWt_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘BldgComp_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN BldgComp_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_BldgComp_c] DEFAULT ((0)) FOR BldgComp_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Invoiced_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Invoiced_c bit NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Invoiced_c] DEFAULT ((0)) FOR Invoiced_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘CompJ_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN CompJ_c bit NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_CompJ_c] DEFAULT ((0)) FOR CompJ_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Po_Target_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Po_Target_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Po_Target_c] DEFAULT ((0.00)) FOR Po_Target_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Cplxty_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Cplxty_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Cplxty_c] DEFAULT ((0.00)) FOR Cplxty_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Multi_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Multi_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Multi_c] DEFAULT ((0.00)) FOR Multi_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Split1_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Split1_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Split1_c] DEFAULT ((0)) FOR Split1_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderDtl’, ‘Split2_c’,1
ALTER TABLE [IM].[IMOrderDtl] ALTER COLUMN Split2_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderDtl] ADD CONSTRAINT [DF_IMOrderDtl_Split2_c] DEFAULT ((0.00)) FOR Split2_c
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘OrderHed’
ZDBCreateChangeCaptureTrigger for UD Table =OrderHed_UD
ALTER TABLE [Erp].[OrderHed_UD] DISABLE TRIGGER TR_OrderHed_UD_ChangeCapture
ALTER TABLE [Erp].[OrderHed_UD] WITH CHECK ADD CONSTRAINT FK_OrderHed_UD_OrderHed FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].OrderHed
ON DELETE CASCADE
ALTER TABLE [Erp].[OrderHed_UD] CHECK CONSTRAINT FK_OrderHed_UD_OrderHed
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘OrderHed’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[OrderHed] AS
SELECT a., b. FROM [Erp].[OrderHed] a
LEFT OUTER JOIN [Erp].[OrderHed_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.OrderHed’
EXEC [Ice].[SPCreateUDForIM] Erp,OrderHed
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘Split_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN Split_c bit NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_Split_c] DEFAULT ((0)) FOR Split_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘SplitNotes_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN SplitNotes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_SplitNotes_c] DEFAULT (’’) FOR SplitNotes_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘PL_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN PL_c bit NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_PL_c] DEFAULT ((0)) FOR PL_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘PLNotes_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN PLNotes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_PLNotes_c] DEFAULT (’’) FOR PLNotes_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘Blast_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN Blast_c bit NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_Blast_c] DEFAULT ((0)) FOR Blast_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘BlastNotes_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN BlastNotes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_BlastNotes_c] DEFAULT (’’) FOR BlastNotes_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘NegSplit_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN NegSplit_c bit NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_NegSplit_c] DEFAULT ((0)) FOR NegSplit_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘NegSplitNotes_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN NegSplitNotes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_NegSplitNotes_c] DEFAULT (’’) FOR NegSplitNotes_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘DisApp_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN DisApp_c bit NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_DisApp_c] DEFAULT ((0)) FOR DisApp_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘DisAppNotes_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN DisAppNotes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_DisAppNotes_c] DEFAULT (’’) FOR DisAppNotes_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘Coor_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN Coor_c nvarchar(20) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_Coor_c] DEFAULT (’’) FOR Coor_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘estim_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN estim_c nvarchar(20) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_estim_c] DEFAULT (’’) FOR estim_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘DP_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN DP_c bit NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_DP_c] DEFAULT ((0)) FOR DP_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘DPA_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN DPA_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_DPA_c] DEFAULT ((0.00)) FOR DPA_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘DPD_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN DPD_c date
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘DPNotes_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN DPNotes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_DPNotes_c] DEFAULT (’’) FOR DPNotes_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘Split1_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN Split1_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD CONSTRAINT [DF_IMOrderHed_Split1_c] DEFAULT ((0.00)) FOR Split1_c
EXEC Ice.DropColumn ‘IM’, ‘IMOrderHed’, ‘Split2_c’,1
ALTER TABLE [IM].[IMOrderHed] ALTER COLUMN Split2_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMOrderHed] ADD
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘ProjectCst’
ZDBCreateChangeCaptureTrigger for UD Table =ProjectCst_UD
ALTER TABLE [Erp].[ProjectCst_UD] DISABLE TRIGGER TR_ProjectCst_UD_ChangeCapture
ALTER TABLE [Erp].[ProjectCst_UD] WITH CHECK ADD CONSTRAINT FK_ProjectCst_UD_ProjectCst FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].ProjectCst
ON DELETE CASCADE
ALTER TABLE [Erp].[ProjectCst_UD] CHECK CONSTRAINT FK_ProjectCst_UD_ProjectCst
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘ProjectCst’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[ProjectCst] AS
SELECT a., b. FROM [Erp].[ProjectCst] a
LEFT OUTER JOIN [Erp].[ProjectCst_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.ProjectCst’
EXEC [Ice].[SPCreateUDForIM] Erp,ProjectCst
EXEC Ice.DropColumn ‘IM’, ‘IMProjectCst’, ‘AVP_c’,1
ALTER TABLE [IM].[IMProjectCst] ALTER COLUMN AVP_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMProjectCst] ADD CONSTRAINT [DF_IMProjectCst_AVP_c] DEFAULT ((0.00)) FOR AVP_c
EXEC Ice.DropColumn ‘IM’, ‘IMProjectCst’, ‘BackCharge_c’,1
ALTER TABLE [IM].[IMProjectCst] ALTER COLUMN BackCharge_c decimal(12,2) NOT NULL
ALTER TABLE [IM].[IMProjectCst] ADD CONSTRAINT [DF_IMProjectCst_BackCharge_c] DEFAULT ((0)) FOR BackCharge_c
EXEC Ice.DropColumn ‘IM’, ‘IMProjectCst’, ‘BackCharge_Date_c’,1
ALTER TABLE [IM].[IMProjectCst] ALTER COLUMN BackCharge_Date_c date
EXEC Ice.DropColumn ‘IM’, ‘IMProjectCst’, ‘Notes_c’,1
ALTER TABLE [IM].[IMProjectCst] ALTER COLUMN Notes_c nvarchar(max) NOT NULL
ALTER TABLE [IM].[IMProjectCst] ADD CONSTRAINT [DF_IMProjectCst_Notes_c] DEFAULT (’’) FOR Notes_c
EXEC [Ice].[SPCreateTriggerForUDCreateView] ‘Erp’, ‘ProjPhase’
ZDBCreateChangeCaptureTrigger for UD Table =ProjPhase_UD
ALTER TABLE [Erp].[ProjPhase_UD] DISABLE TRIGGER TR_ProjPhase_UD_ChangeCapture
ALTER TABLE [Erp].[ProjPhase_UD] WITH CHECK ADD CONSTRAINT FK_ProjPhase_UD_ProjPhase FOREIGN KEY([ForeignSysRowID])
REFERENCES [Erp].ProjPhase
ON DELETE CASCADE
ALTER TABLE [Erp].[ProjPhase_UD] CHECK CONSTRAINT FK_ProjPhase_UD_ProjPhase
IF NOT EXISTS (SELECT 1 from sys.objects WHERE name = ‘ProjPhase’ AND SCHEMA_NAME(schema_id) = ‘dbo’ AND type = ‘V’)
BEGIN
DECLARE @SQL as varchar(4000)
SET @SQL=
‘CREATE VIEW [dbo].[ProjPhase] AS
SELECT a., b. FROM [Erp].[ProjPhase] a
LEFT OUTER JOIN [Erp].[ProjPhase_UD] b
ON a.SysRowID = b.ForeignSysRowID’
EXEC (@SQL)
END
ELSE exec sp_refreshview ‘dbo.ProjPhase’
DECLARE @TableSchema sysname,
@TableName sysnam
Execute Phase Complete: 36.0137556 seconds
Starting Cleanup Phase…
- Post Migration
Cleanup Phase: 0.016457 seconds
DB Migration process is cancelled by the user.
The total execution time is 0.6345 minutes.