Add script generation to migrations tool about efcorepowertools HOT 6 CLOSED

The Migrations tool should support scripting already, but it looks like there is a bug with EF Core 8, where the tool continues to detect pending changes - I will have a closer look

from efcorepowertools.

@blahDL This is already available in the Migrations tool - but only visible once migrations have been applied

from efcorepowertools.

There is also a bad pattern if the database does not exist, wonder if I should just attempt to create it if it does not exist.

Let me try that.

from efcorepowertools.

@blahDL This is already available in the Migrations tool - but only visible once migrations have been applied

It would be better if the scripting options were available without requiring the database to be up to date, that is probably why I didn't see the scripting options available. Unfortunately we have occasional issues with the migrations fail because of indexes or statistics that exist in a database but not in the context (we have multiple client databases that existed 20 years before we started using EF on them and were manually maintained in that time) so we sometimes need to comment out individual lines in the SQL to update the client databases.

from efcorepowertools.

I am seriously considering dropping this feature, as it is now built into VS:

https://youtu.be/UEqx0c-Dnec?si=4R6q_ubN693iUM1U&t=162

from efcorepowertools.

I have dropped this feature now...

from efcorepowertools.