Hi,
I have an Umbraco site that I migrated from v7.4.1 to v12.2.0 (it took a while). I pulled the database from the hosted SQL on Websupport (old Binero) and had to change hosting to be GoDaddy instead as Websupport does not support .NET Core.
The local site in v12 runs perfectly using the locally hosted MSSQL database used.
The issue is when I deploy the site and database to the Plesk portal on GoDaddy (via a create and populate data script from the local MSSQL database. From what I can see the MSSQL database hosted at GoDaddy contains the same amount of tables and content (did some tests here and there).
Issue number 1:
When I run the site locally and tries to access the hosted MSSQL site I end up in the “Install Umbraco” page. Almost like the site can access the database, but it does not find the tables within.
The site I tried different ways from VS2022 to deploy the site via FTP and deploy configs. I ended up using the downloadable “Web Deploy Publishing Settings” in Plesk.
Issue numer 2:
When I access the hosted URL in GoDaddy, I end up in a 500.30 error page. But no logs is created.
EDIT:
Issue number 1 was resolved by letting the locally running webpage create the tables in the hosted database, then the correct schema was set based on the SQL user used in Plesk (as this user only had read/write access to the database). Then I used the uSync package for Umbraco 12 to export complete setup from the local database (running the local Umbraco page pointing to my local database), repoint to the hosted database from local running site, and import the full package. After this the local running website that was pointing to the hosted database was working perfectly.
Still issue number 2 is there for hosted site, but might think that this is due to incorrect deployment.
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/113098-deploy-local-umbraco-v12-site-to-godaddy