Zero to MVP with C# and dotNet - Migrate the local SQL database to Azure
I spend a lot of time talking about organization of a SQL Database in this session.
I don't like stuffing everything into dbo.**** anymore. Sometimes, we find that it's necessary to pull some of our storage objects into their own storage service, and move the access to those resources out of the main application and into its own hosting space. Putting all of the data into a single unit of organization makes that MUCH more difficult (aka: expensive) later.
I ported the important objects out of my local SQL Server container instance to the Azure SQL Database, ran my application and was able to create a new character, get an AI description, save it to the Azure database, and retrieve it in the list without too much trouble at all.
Nice!
This afternoon, I'll hoist my actual application into an app service instance and get it configured and internally secured using Azure features. (No public access yet. Sorry, eh?)
-- Follow the project progress at: https://www.thatdeveloperdad.com/post...
-- Github: https://github.com/ThatDeveloperDad/G...
-- Watch live at / thatdeveloperdad
— Music by Karl Casey @ White Bat Audio