C#•15mo ago

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.

Jimmacle•10/11/24, 5:32 PM

you need to delete all the migrations that were created against sql server and create one for mysql

Jimmacle•10/11/24, 5:33 PM

and check the code for any sql server specific functions being used

CykotechOP•10/11/24, 5:38 PM

Perfect. Thank you so much!

Jimmacle•10/11/24, 5:48 PM

i should clarify, delete everything in the migrations folder including the snapshot

Jimmacle•10/11/24, 5:48 PM

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

CykotechOP•10/11/24, 5:51 PM

Yea that's what I did. It makes sense knowing that was the problem.

Convert from MSSql to MySql

Similar Threads

Similar Threads

Similar Threads