I am a newcomer to Umbraco and currently I have been able to succesfully debug and host Umbraco locally.
However if I do web deploy either with Visual Studio or Web Matrix, I always get an Umbraco installation page when I browse my domain. I do not want to create a blank database but use the existing one I have modified locally.
I can see that the Umbraco.sdf file is located in AppData folder on my server.
I have installed SQL Server Compact from NuGet in Visual Studio. I have installed the same version to the destination server.
Why Umbraco still wants to create a blank database and how can I force Umbraco to use the existing sdf database file?
Publishing with local SQL Server Compact (.sdf)
Hello,
I am a newcomer to Umbraco and currently I have been able to succesfully debug and host Umbraco locally.
However if I do web deploy either with Visual Studio or Web Matrix, I always get an Umbraco installation page when I browse my domain. I do not want to create a blank database but use the existing one I have modified locally.
I can see that the Umbraco.sdf file is located in AppData folder on my server.
I have installed SQL Server Compact from NuGet in Visual Studio. I have installed the same version to the destination server.
Why Umbraco still wants to create a blank database and how can I force Umbraco to use the existing sdf database file?
Best,
Petri
Fixed.
I had to add connection string to web.config. Thought it was there by default but I was wrong.
Here's the code for others:
<connectionStrings>
<add name="UmbracoDB" connectionString="Data Source=|DataDirectory|Umbraco.sdf" providerName="System.Data.SqlServerCE.4.0"/>
</connectionStrings>
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.