Comments
Sort by recent activity
Close to same thing on v5.3.0.68...
-- Drop constraint DataType_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataType_DataOrigin_FK1]
-- Drop constraint DataType_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataType_DataOrigin_FK1]
-- Drop constraint DataTransmission_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataTransmission_DataOrigin_FK1]
-- Drop constraint DataTransmission_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataTransmission_DataOrigin_FK1]
-- Drop constraint DataFrequency_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataFrequency_DataOrigin_FK1]
-- Drop constraint DataFrequency_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataFrequency_DataOrigin_FK1] / comments
Close to same thing on v5.3.0.68...
-- Drop constraint DataType_DataOrigin_FK1 from [dbo].[DataOrigin]
ALTER TABLE [dbo].[DataOrigin] DROP CONSTRAINT [DataType_DataOrigin_FK1]
-- Drop constraint Da...
The Comparison-->Options I have, and whether they are checked or not, are as follows. These haven't been changed from the defaults. I'm on SDC v3.4.0.8.
[X] Disable Foreign Keys
[ ] Disable Triggers
[ ] Drop primary keys, indexes and unique constraints
[X] Include timestamp columns
[ ] Do not use transactions
[ ] Exclude IDENTITY columns
[ ] Trim trailing spaces
Nothing about ROWGUID. I went through on the wizard and unchecked each of the rowguid columns from the tables before the compare.
This fixed the compare, but I'm unable to sync the rest of the data. i.e. keep the rowguid, but update the names, phone numbers, etc.
I think I can probably gut the script and take out all the rowguid references from the statements, but is there another option? / comments
The Comparison-->Options I have, and whether they are checked or not, are as follows. These haven't been changed from the defaults. I'm on SDC v3.4.0.8.
[X] Disable Foreign Keys
[ ] Disable Trig...
Nevermind, I unchecked the column next to ROWGUID in one table. With that corrected, the sync worked as expected.
Thanks! / comments
Nevermind, I unchecked the column next to ROWGUID in one table. With that corrected, the sync worked as expected.
Thanks!