Activity overview
Latest activity by mfarbstein
Thank you for prompt response.
The source db (2000) has owner x for table a, and owner y for table b. The target db (2005) has schema y for table a, and schema y for table b.
So the owner mapping looks like:
x -> y for table a
y -> y for table b
The Schema Compare fails during the compare step with the error "Item has already been added. Key in dictionary: "table a". Key being added: "table a"."
I think I've got that described correctly. I understand why the error occurs. I could fix this manually by externally changing the owners to be consistent. Having to fix it externally obviates the use of the Schema Compare program. A solution might be to be able to filter out the offending table so the compare completes for the remaining objects. Would appreciate your feedback and suggestions. / comments
Thank you for prompt response.
The source db (2000) has owner x for table a, and owner y for table b. The target db (2005) has schema y for table a, and schema y for table b.
So the owner mapping l...
Owner mapping in schema compare
In the Data Compare, one can map between objects that have different owners, which is a requirement in our environment. However, I cannot find a way to do the equivalent in the Schema Compare. Is t...
trial version
I tried using the trial version of SQL Prompt 2, but as far as I could tell it did not do anything useful. From a query window within SQL Server Management Studio, I could see an occasional pop-up ...