Problems adding my SQL Server database to AppHarbor

jpscott4444's Avatar

jpscott4444

11 Dec, 2017 05:53 PM

Hello. My name is Jeff Scott. I am an Information Technology Instructor. I am using AppHarbor for my ASP.NET class. I have uploaded several non-database ASP.NET apps to AppHarbor with no trouble.

Is there any AppHarbor documentation on how I can upload my local SQL Server database to AppHarbor? I actually have two different ASP.NET MVC database project applications that I would like to upload (separately of course) to AppHarbor. One is database-first and one is code-first.

I went to your FAQ page, but could not find an answer. You have a "Move an existing database to AppHarbor" link that I clicked, but this link is misnamed, as it explains how to move an existing AppHarbor database to the local side.

I also went out to YouTube.com and watched a Lynda.com video at https://www.linkedin.com/learning/asp-dot-net-mvc-5-essential-training/deploying-to-appharbor However, this video references an Application_context.cs file that I do not have.

Any suggestions on how to do BOTH SQL Server database-first and code-first migration to AppHarbor would be most appreciated. Thank you very much.

Jeff Scott,
Wentzville MO

  1. Support Staff 1 Posted by rune on 24 Dec, 2017 09:02 AM

    rune's Avatar

    Hi Jeff,

    Apologies for the slow response! We don't have recent articles on how to perform Code First migrations, but you may still find the older ones relevant depending on the Entity Framework version you're using - take a look at my response in this thread for a few more references on that subject.

    With regards to database-first I suspect that'd be something you'd set up independently of Entity Framework migrations? I mean you might set up the Sequelizer/AppHarbor-hosted database with your required schemas etc, and then connect your local application to in order to generate any Entity Framework data models as described here (and commit the generated models before pushing to an AppHarbor app).

    Also, have you experienced issues with this on any AppHarbor-hosted apps? Happy to take a closer look if you let me know the application name(s), and see if I can provide more specific guidance based on your implementation.

    Best,
    Rune

Discussions are closed to public comments.
If you need help with AppHarbor please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac