Activity overview
Latest activity by MMeenan
Still getting the failure on Sync. I added the "do not include plumbing for transactional...".
Still fails with same error. / comments
Still getting the failure on Sync. I added the "do not include plumbing for transactional...".
Still fails with same error.
I should have guessed that one.
I just ran the compare sucessfully. I am getting the following issue when I attempt the sync:
The following error message was returned from the SQL Server:
============================================
[1776] There are no primary or candidate keys in the referenced table 'dbo.ORG40100' that match the referencing column list in the foreign key 'orgRelation_MSTR'.
Could not create constraint. See previous errors.
The following SQL command caused the error:
ALTER TABLE [dbo].[ORG00100] ADD
CONSTRAINT [orgRelation_MSTR] FOREIGN KEY ([ENTITYID]) REFERENCES [dbo].[ORG40100] ([ENTITYID])
=============================================
I'm not sure, but I'm thinking it ma be a dependency issue.
Ideas? / comments
I should have guessed that one.
I just ran the compare sucessfully. I am getting the following issue when I attempt the sync:
The following error message was returned from the SQL Server:
========...
Item Already Added. Key in Dictionary..
I'm trying to compare a DB on the live server (SQL 2000 Binary/Case Sens)
to a DB on Dev Server that is SQL 200 default colation/sort. Goal is to move current live DB to a new server with default ...