Last post Oct 25, 2018 03:24 PM by mgambone
Oct 25, 2018 12:32 PM|mgambone|LINK
I'm developing a website that needs individual user authentication using ASP.NET Framework MVC template. It automatically created a LocalDb\MSSQLLocalDB backend database for user authentication.
I've read somewhere that LocalDb should NOT be used for production server. Is this true? If so, how do I convert this LocalDb into a full SQL Server database without "breaking" any of the authentication codes in my Login/Register web pages?
Appreciate any help.
Oct 25, 2018 01:31 PM|Mikesdotnetting|LINK
I've read somewhere that LocalDb should NOT be used for production server. Is this true?
how do I convert this LocalDb into a full SQL Server database
This is most easily accomplished by crating your backup, then creating a new blank database on the production server, then restoring from the back up using the Replace option to overwrite the blank database.
Then you need to change the connection string to point to the new instance.
Oct 25, 2018 03:24 PM|mgambone|LINK
Thank you. I was afraid I'd have to redo the whole thing.