Comments
3 comments
-
Hi @cax20,
Can you try this on the latest version of Schema Compare for Oracle and see if you get the same results? The latest version is 4.0.10 (download here).
Kind regards,
Alex -
I will. but it will take a while, as i have to go through an approval cycle for all foss/cots upgrades.
Are you suggesting this because you know of changes to newer versions that would help with my problem? i.e. should i be optimistic?
-
Hi @cax20,
I've just finished going over this and it seems you will need to use the /resolve:<issue>:<resolution> switch to resolve the conflict, even in the latest version.
The command I ran first was just to create the deployment script file rather than deploy it:"C:\Program Files\Red Gate\Schema Compare for Oracle 4\SCO.exe" /source:scott/tiger@TNS{schema} /target:scott/tiger@TNS{schema} /scriptfile:"E:\Path\to\script.sql"
and it provided the content of the conflict:Finding issues with deploymentIssue: ConstraintNameAlreadyInTarget: schema.the_constraintResolutions: UseSystemName,IgnoreResolution: UseSystemNameUse an automatically generated nameIssue: IndexNameAlreadyInTarget: schema.the_constraint
Resolutions: UseSystemName,IgnoreResolution: UseSystemNameUse an automatically generated nameSo the command would becomeConstraintNameAlreadyInTarget:UseSystemName"C:\Program Files\Red Gate\Schema Compare for Oracle 4\SCO.exe" /source:scott/tiger@TNS{schema} /target:scott/tiger@TNS{schema} /scriptfile:"E:\Path\to\script.sql" /resolve:
This will cause a system generated constraint name to be used and the deployment (or created deployment script) will be run successfully.
Otherwise you will need to manually edit the script to reorder the command.
Kind regards,
Alex
Add comment
Please sign in to leave a comment.
A user renamed a table. The table had constraints on it. He did not rename the constraints.
The ensuing delta had the create (new) table command before the drop (old) table command. When i applied the delta, i got errors saying the constraint already existed. I flipped the order manually (placing the drop first) which succeeded, but am trying to limit human intervention.
Have you guys discussed this? if so, please me point me to the conversation. else, any thoughts?