What is the correct way to deploy Lightswitch project database changes to existing databases?

Question

If you are using a Lightswitch project to manage your entities and database changes, how do you deploy changes to the entities to an existing, already deployed project database? Is the best way to run schema compare on the two db versions?

Answer 1

The LightSwitch Publish wizard automatically creates a change script. It will also stop you if it cannot properly update the database schema (because you have a change that would corrupt data integrity).

LightSwitch does this by examining the destination database and comparing that to the database schema that you are trying to deploy.