Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Magnus Janson 14 posts 74 karma points
    May 28, 2014 @ 23:41
    Magnus Janson
    0

    Umbraco database

    I have installed my first Umbraco project, the Txt starter kit in Visual Studio 2013. I am confused about the Umbraco database. In fact, I can't find it...

    I was expecting to see it in Server Explorer of Visual Studio. I don't.

    I was expecting to see it in SQL Server Management Studio. I don't.

    I was expecting to see it in SQL Server Configuration Manager. I don't.

    I was expecting to see a database file in the Visual Studio project. I did. I saw that it is actually a SQL Server Compact Edition file. Maybe this explains why I cannot see it in any tools?

    What can I do?

    Thanks.

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    May 29, 2014 @ 00:23
    Jan Skovgaard
    0

    Hi Magnus and welcome to our :)

    If you did not customize your installation then the database in use is the CE SQL 4.0 database, which is embedded.

    You can find the umbraco.sdf file in the /app_data/ folder - If you want to migrate it to MSSQL you can use webmatrix to do it. It's usually pretty smooth.

    Hope this answers your question.

    /Jan

    Copy Link
  • Magnus Janson 14 posts 74 karma points
    May 30, 2014 @ 22:11
    Magnus Janson
    0

    Thanks, Jan.

    I installed SQL Server Compact Toolbox, so I can manage CE databases.

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    May 31, 2014 @ 09:56
    Jan Skovgaard
    100

    Hi Magnus

    Happy to hear it helped - Please don't hesitate to ask further questions since we're a friendly bunch of people who wants to help each other out :)

    Remember to mark the post as solved btw.

    Cheers, Jan

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft