Sign in Register
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 11258 posts 23500 karma points MVP 7x 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 11258 posts 23500 karma points MVP 7x 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

  • 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.

Please Sign in or register to post replies