Currently the sites that I am building aren't big enough to warrant their own SQL Server DB.
Instead i use SQL CE. I use Git and GitHub for Source Control.
I have noticed when i develop, if i build some document types and fill in some content, when i go back the document types are gone and the content is missing. This happens randomly throughout the development process.
Is this a common issue with SQL CE? I have also noticed it takes multiple publishes to get content to update sometimes.
This issue takes place weather I have committed files and pushed them or not.
Ive considered keeping my database out of the git folder and changing the web config to connect to it somewhere on my C:\
You should migrate to MSSQL - Unfortunately it's a known issue, which you can see here http://issues.umbraco.org/issue/U4-4621 - Not convinced that it's Umbraco's fault though. But not certain why it happens.
Yes it can help but I've seen it act up the same way even using a real IIS. But you're welcome to try doing it and see if it works but if you want to have that nice feeling in your stomach then it's probably better to consider using MSSQL Express.
Local SQL CE .sdf File - Things keep reverting
Hello,
Currently the sites that I am building aren't big enough to warrant their own SQL Server DB.
Instead i use SQL CE. I use Git and GitHub for Source Control.
I have noticed when i develop, if i build some document types and fill in some content, when i go back the document types are gone and the content is missing. This happens randomly throughout the development process.
Is this a common issue with SQL CE? I have also noticed it takes multiple publishes to get content to update sometimes.
This issue takes place weather I have committed files and pushed them or not.
Ive considered keeping my database out of the git folder and changing the web config to connect to it somewhere on my C:\
Hi James
You should migrate to MSSQL - Unfortunately it's a known issue, which you can see here http://issues.umbraco.org/issue/U4-4621 - Not convinced that it's Umbraco's fault though. But not certain why it happens.
Perhaps MSSQL Express could be an option?
Hope this helps.
/Jan
Shame because it packages the whole site up in one directory :(
Guiess ill Switch to MSSQL EXpress
Thanks for the heads up!
It appears as though setting up a local development site in real IIS is the key to this one !
Hi James
Yes it can help but I've seen it act up the same way even using a real IIS. But you're welcome to try doing it and see if it works but if you want to have that nice feeling in your stomach then it's probably better to consider using MSSQL Express.
But if it's not too critical give it a shot :)
/Jan
MSSQL Express is freely available, so ill probably move to using that :)
Thanks for all your input.
is working on a reply...