Activity overview
Latest activity by KieranDonoghue
Hi there - I appear to have the exact opposite problem. I have a column on a table which was reused rather than renamed. What occurred is that a column was no longer required (AllowedFunctionID) but a new column (AllowedFunctionModeLinkID) had the same characteristics (Int) so this column was reused. This old column had a FK constraint on one table (AllowedFunction) which obviously existed in the target database but the new column had a FK to a new table (AllowedModeFunction). When this was being synchronised it tried to take the data from the old column and insert it into the new column. This caused a problem as it would not pass FK constraints as there was no data on the new table. At first I thought this was behaving correctly as it is probably better to try and conserve data rather than delete it but I then saw this thread and did some more investigating. I renamed some other columns and deleted and set up some columns and these dropped the data when synchronised. These had no FK or other constraints. This seems to be inconsistent. I attach the Insert line from the synchronisation script which shows the data being moved from AllowedFunctionID to AllowedFunctionModeLinkID :[INSERT INTO [dbo].[tmp_rg_xx_cmasUserPermission]([UserPermissionID], [RoleID], [AllowedFunctionModeLinkID], [EnteredBy], [EnteredDate], [LastUpdatedBy], [LastUpdatedDate], [CheckedBy], [CheckedDate], [AuthorisedBy], [AuthorisedDate]) SELECT [UserPermissionID], [RoleID], [AllowedFunctionID], [EnteredBy], [EnteredDate], [LastUpdatedBy], [LastUpdatedDate], [CheckedBy], [CheckedDate], [AuthorisedBy], [AuthorisedDate] FROM [dbo].[cmasUserPermission]] If I move the position of the column it will drop the data.[/quote] / comments
Hi there - I appear to have the exact opposite problem. I have a column on a table which was reused rather than renamed. What occurred is that a column was no longer required (AllowedFunctionID) ...