Is_System_Named
Issue in Database Deployment in Agile Process
When you migrate the DDL from one server to another server
in agile development then the major problem you will face because of constraints
name. As all comparison tool have same problem; it will give the differences if
you have only constraints name different even for same constraint. That will
suggest you to delete and recreate the constraint with the source name you
have. So suppose if a primary key is getting created without specifying the name
then system will give one unique name to the primary key. So while comparing
two database will show you differences because the name of the primary key is different
even though we have same primary key (on same table , same column). Then the
tool will suggest you to delete this primary key and recreate with source
primary key name. As this primary key is referring many foreign key you have to
first delete all the foreign key then delete the primary key and recreate the
primary key and then back create all the foreign keys.