I'm getting the following error when performing a deployment of a database package for the first time:
- Code: Select all
2014-01-23 17:21:35 +00:00 INFO The last deployment details were not found in the target database. Static upgrade is not available
2014-01-23 17:21:35 +00:00 INFO Upgrade script not available; performing dynamic database upgrade
2014-01-23 17:21:35 +00:00 INFO Loading source database from db\\state
2014-01-23 17:21:35 +00:00 INFO - Using SOC filter file at db\\state\\Filter.scpf
2014-01-23 17:21:35 +00:00 INFO - Using default Compare options
2014-01-23 17:21:35 +00:00 INFO - Loading as case-insensitive (based on target database)
2014-01-23 17:21:35 +00:00 INFO Registering target database
2014-01-23 17:21:38 +00:00 INFO Registering scripts folder
2014-01-23 17:21:39 +00:00 ERROR Error while executing job: Dynamic deployment failed
2014-01-23 17:21:39 +00:00 ERROR A duplicate definition was found for the stored procedure [dbo].[<ProcedureName>]. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, contact our support.
If I re-run the deployment, I get a different object name each time. The database I'm deploying to is marked as collation insensitive (CI) and accent sensitive (AS).
Any thoughts on how I can resolve this?
Thanks in advance.