If you add Umbraco to your project in Visual Studio and you run your project for the first time then you have the possibility to customize the SQL syntax.
As default it uses SQL CE which means it will create a .sdf data file located under the App_Data folder which contains all the umbraco data.
Another way is to install Sql Managament Studio ( Preferred! ) and then connect to this during your installation.
That's interesting. Could you say that SQL CE is a tiny "fall-back" solution when Umbraco doesn't detect (or isn't supplied with) a SQL server connection?
Because earlier when I did a test-install of Umbraco, it didn't ask me any SQL server details and I was wondering why it can work without it.
Umbraco 7 in VS, what about database?
Hi all,
I'm about to dive into the world of .NET and Umbraco and I have a question regarding Visual Studio.
I'm assuming that getting Umbraco to run on Visual Studio should be a peace of cake right?
My main question is, does Visual Studio have built-in SQL "server" that Umbraco can connect to and store data in?
Hi Faloude,
If you add Umbraco to your project in Visual Studio and you run your project for the first time then you have the possibility to customize the SQL syntax.
As default it uses SQL CE which means it will create a
.sdfdata file located under theApp_Datafolder which contains all the umbraco data.Another way is to install Sql Managament Studio ( Preferred! ) and then connect to this during your installation.
Then you can work nicely with your database.
Hope this helps!
/Michaël
That's interesting. Could you say that SQL CE is a tiny "fall-back" solution when Umbraco doesn't detect (or isn't supplied with) a SQL server connection?
Because earlier when I did a test-install of Umbraco, it didn't ask me any SQL server details and I was wondering why it can work without it.
Hi Faloude,
After you have entered your details you have a button
Customize.If you click on that you can choose your installation type for the database.
If you leave it then it uses SQL CE by default ( like in your case ).
So in your
App_Datayou will find a name with the.sdfextension./Michaël
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.