Options
Suppress Compare Errors
fraudh8er
Posts: 18
Is there a way to suppress erros on an SYNC. I am doing a synch everytime I get an error, I have to go back and deal with it and run the compare again. Is there a way to suppress the errors and then get a report of the problems after the sync is done. It is rolling back the databases when it gives me a error.
Thank you
Thank you
"On the Road of Life there are Passengers and Drivers, Which Are You....?"
This discussion has been closed.
Comments
- Neil
Red Gate Software Ltd
This is Error Number Two
This is Error Number Three:
The following error message was returned from the SQL Server:
[515] Cannot insert the value NULL into column 'SDate', table 'SSLeSueurCopy.dbo.Jail_Record_Suicide'; column does not allow nulls. UPDATE fails.
The following SQL command caused the error:
ALTER TABLE [dbo].[Jail_Record_Suicide] DROP
COLUMN [ID]
ALTER TABLE [dbo].[Jail_Record_Suicide] ALTER COLUMN [Jail_ID] [int] NOT NULL
ALTER TABLE [dbo].[Jail_Record_Suicide] ALTER COLUMN [SDate] [datetime] NOT NULL
ALTER TABLE [dbo].[Jail_Record_Suicide] ALTER COLUMN [STime] [datetime] NOT NULL
This is Error Number Four
The following error message was returned from the SQL Server:
[515] Cannot insert the value NULL into column 'ID', table 'SSLeSueurCopy.dbo.tmp_rg_xx_IR_Statement'; column does not allow nulls. INSERT fails.
The following SQL command caused the error:
INSERT INTO [dbo].[tmp_rg_xx_IR_Statement]([Case_ID], [Case_Number], [SSQ], [SDate], [STime], [SLocation], [SName], [DOB], [Age], [SSN], [SAddress], [SCity], [SState], [SZip], [SPhone], [SEmployer], [Officer], [Officer_ID], [SNarrative], [Complete_Date], [Complete_Time], [WitnessA], [WitnessB], [MNI_No], [SType]) SELECT [Case_ID], [Case_Number], [SSQ], [SDate], [STime], [SLocation], [SName], [DOB], [Age], [SSN], [SAddress], [SCity], [SState], [SZip], [SPhone], [SEmployer], [Officer], [Officer_ID], [SNarrative], [Complete_Date], [Complete_Time], [WitnessA], [WitnessB], [MNI_No], [SType] FROM [dbo].[IR_Statement]
This is Error Number Five
The following error message was returned from the SQL Server:
[515] Cannot insert the value NULL into column 'UCR_CHECK_ID', table 'SSLeSueurCopy.dbo.tmp_rg_xx_List_Box_UCR_Check'; column does not allow nulls. INSERT fails.
The following SQL command caused the error:
INSERT INTO [dbo].[tmp_rg_xx_List_Box_UCR_Check]([ERRORDER]) SELECT [ErrOrder] FROM [dbo].[List_Box_UCR_Check]
The following messages were returned from the SQL Server:
Error Six
The following error message was returned from the SQL Server:
[515] Cannot insert the value NULL into column 'Action', table 'SSLeSueurCopy.dbo.tmp_rg_xx_Menu_List'; column does not allow nulls. INSERT fails.
The following SQL command caused the error:
INSERT INTO [dbo].[tmp_rg_xx_Menu_List]([ID], [ReportName], [ReportType], [Report_Description], [City], [State], [User_Level], [PreFunction], [Identifier], [Order]) SELECT [ID], [ReportName], [ReportType], [Report_Description], [City], [State], [User_Level], [PreFunction], [Identifier], [Order] FROM [dbo].[Menu_List]
Red Gate Software Ltd
Thank you Neil
Red Gate Software Ltd
Red Gate Software Ltd