7

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?

Sam Johnson
  • 973
  • 9
  • 21
Don Becker
  • 133
  • 5
  • Are the changes not being reflected when you publish? I've been developing locally, and it seems that changes to the entities in Lightswitch are automatically made to the database during publish. Let me know if you see some other behavior. – Sam Johnson Apr 18 '11 at 17:46
  • I would like to at least check the result with a tool like SqlCompare – Ian Ringrose May 17 '11 at 16:09

1 Answers1

3

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.

Michael Washington
  • 2,744
  • 20
  • 29
  • Hi Michael, so what would you do in this case? We are updating the schema frequently and it keeps erroring and we have to blow away the database and deploy from fresh (it's not yet released so this is ok and the easiest) - how will we do updates in the future? – Rodney Aug 14 '12 at 04:42
  • I have not experienced that, I am sorry. – Michael Washington Aug 15 '12 at 12:50
  • This issue is also frustrating for me. We would like an option to ignore data integrity! – cmaduro Mar 25 '13 at 14:59