Database replication will always fail. What you need to do is treat database changes no different that software changes. Developers should make modifications to

Database replication will always fail. What you need to do is treat database changes no different that software changes. Developers should make modifications to there local database (they are running local right) and then as they complete their work. The need to script the DDL and DML. This way, the changes can be versioned and applied in sequence to existing environments as well as new environments. The root of all change in a system should always be versioning, to try to manage it any other way is inviting trouble.