Convert from MSSql to MySql
I'm trying to convert this MSDoc tutorial project from a local instance of MSSql to a MySql server. I'm fairly certain I've gotten all the configuration correct, except the syntax differences of MSSql to MySql. (i.e nvarchar) I pushed it to GitHub if someone is able to take a peek at it. Thanks in advance.
https://github.com/Cykotech/RazorPagesMovie
GitHub
GitHub - Cykotech/RazorPagesMovie
Contribute to Cykotech/RazorPagesMovie development by creating an account on GitHub.
4 Replies
you need to delete all the migrations that were created against sql server and create one for mysql
and check the code for any sql server specific functions being used
Perfect. Thank you so much!
i should clarify, delete everything in the migrations folder including the snapshot
the snapshot is how EF figures out what changed in the model since the last migration was created and you want to start over from scratch
Yea that's what I did. It makes sense knowing that was the problem.