I recently created a new site in Umbraco Cloud where I started the solution on a starter subscription and later upgraded to Pro version.
I just went with using the filebased umbraco.mdf database for local development purposes and now I wanted to create a few custom tables, one of which would make sense to relate to the UFRecord table.
However, when I attach the database file (Umbraco.mdf) in MSSQL Management Studio and expand the Tables, the Umbraco Forms tables are not there, even though the section in Umbraco runs just as it should: I can create forms, workflows etc :-)
I've tried to remove the "install" file which lives in App_Plugins/UmbracoForms/ hoping that it would've (re)publish the tables when the app pool was refreshed, but they don't seem to get published.
Am I missing something completely obvious here?
Thanks a lot in advance :-)
Screenshot of the umbraco.mdf database for convenience:
I suspect, looking at your SQL Server version, that the mdf file isn't being used by your local copy. I suspect it is actually using LocalDb instead. The Cloud project checks if LocalDb is available and if it does it uses that instead of SQLCE.
If you want to check this, put this put a breakpoint in your master layout file and perform a Watch on
Sure enough, the tables resided in the SDF file rather than the MDF file. Learned something new today ;-)
Installed the VS extension from your link and migrated SDF db to a local, regular SQL database instead. I'm probably just a grumpy, ol' man, but somehow I prefer a "real" database rather than a file.
Anyhow, everything works just as it should now. Thanks a lot for your help :-)
Umbraco Forms tables missing in umbraco.mdf
Hi all,
I recently created a new site in Umbraco Cloud where I started the solution on a starter subscription and later upgraded to Pro version.
I just went with using the filebased umbraco.mdf database for local development purposes and now I wanted to create a few custom tables, one of which would make sense to relate to the UFRecord table.
However, when I attach the database file (Umbraco.mdf) in MSSQL Management Studio and expand the Tables, the Umbraco Forms tables are not there, even though the section in Umbraco runs just as it should: I can create forms, workflows etc :-)
I've tried to remove the "install" file which lives in App_Plugins/UmbracoForms/ hoping that it would've (re)publish the tables when the app pool was refreshed, but they don't seem to get published.
Am I missing something completely obvious here?
Thanks a lot in advance :-)
Screenshot of the umbraco.mdf database for convenience:
Hi Bo,
I suspect, looking at your SQL Server version, that the mdf file isn't being used by your local copy. I suspect it is actually using LocalDb instead. The Cloud project checks if LocalDb is available and if it does it uses that instead of SQLCE.
If you want to check this, put this put a breakpoint in your master layout file and perform a Watch on
This should, I suspect, point you to LocalDb instead of a SQL CE connection.
Nik
Thanks for your reply, Nik :-) Greatly appreciated.
You may be right. I'm not very familiar with file-based dbs, I must admit. The connection string looks like this:
Isn't that supposed to use the umbraco.mdf file, or? :-)
Thanks again!
Hi Bo,
Nope, that looks like it should be creating a SDF file in App_Data not an MDF file.
To access an SDF file, you will probably want to use this extension for Visual Studio https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox
There is still a possibility that LocalDB is being used as well, but check if you have an SDF file first.
Nik
Hi Nik,
Sure enough, the tables resided in the SDF file rather than the MDF file. Learned something new today ;-)
Installed the VS extension from your link and migrated SDF db to a local, regular SQL database instead. I'm probably just a grumpy, ol' man, but somehow I prefer a "real" database rather than a file.
Anyhow, everything works just as it should now. Thanks a lot for your help :-)
is working on a reply...