I recently deployed Entity Framework Code First project and had a few problems. After a bit of debugging it turn out the problem was because EF Code First was trying to drop and recreate the database and AppHarbor doesn't give you create permissions. The solution was…
- Remove the SQL add-on from AppHarbor and re-add it again as EF had dropped the database.
- Change the call to Database.SetInitializer in your context class to look like this
- Script your EF database and run the script on the AppHarbor database to create your database objects.
Assuming the connection strings are all set up correctly you should be good to go.