I am developing an ASP.Net web application using Visual Studio 2017. After some initial development work which has been successfully published to my remote server, I have now added some simple database functionality. I am using Entity Framework to access
a LocalDb database which was created on the initial migration.
I want to publish this new version of my project, including the new database, but can't figure out how to transfer the new database from my development computer to my server.
I had expected to be able to `Backup` my localDb database using SQL Server Management Studio (v17.2) and `Restore` the database onto the SQLExpress instance on my server but I can't see the database to perform this operation.
My development computer runs Windows 7 (64 bit) so I cannot install SQL Server Express 2016. Should I install an earlier version of SQL Server Express on my development computer and use that to host my project's database?
If I continue to use the localDb database through Visual Studio can anyone please advise how I should migrate it to my server running SQLExpress 2016?