Activity overview
Latest activity by lund0529
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...
SDC5 Trying to drop the same constraint multiple times?
Running against two SQL Server 2K databases, I get an error that [DataTransmission_DataOrigin_FK1] is not a constraint. When I examine the SQL, I notice that SDC is trying to drop the same constra...
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!
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...
Ignore ROWGUID column?
Hello - I have two datbases that are the same except for they ROWGUID replication column. Is there a way to exclude this column from the comparison?
I know I have a handful of records that need to...
How do I ignore msrepl_tran_version replication columns?
Replication creates the column msrepl_tran_version in my replicated tables. Is there a way to not have this column created when synchronizing databases with SQL Compare and further ignore it when ...