Insert Script fails because Foreign Keys in Shadow Database
I can deploy fine but when I try to "refresh" from the Ready Roll pane I get a SQL Server error that the script fails because of a foreign key violation. This is obviously because the Shadow database contains no data but still contains foreign keys.
How do I get around this? I have read the articles on data population scripts but they all seem to assume you are deploying to a blank database. Where are you supposed to put maintenance/bug-fix scripts like this?