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


  • Rayyan 46 posts 238 karma points
    Oct 13, 2017 @ 07:06
    Rayyan
    0

    Umbraco Local Connection String Path

    Hello there,

    I have a big sql file that i need to run in Umbraco database that located on the local machine using a tool as shown in the attached screenshot.

    How to figure out what is the connection string for that database?

    BigRunner Screenshot

    Thank you,

    Copy Link
  • Michaël Vanbrabandt 863 posts 3343 karma points c-trib
    Oct 13, 2017 @ 07:44
    Michaël Vanbrabandt
    0

    Hi Rayyan,

    to know the connection string of your Umbraco website, just go to the web.config file and search for ConnectionString.

    Then you will see something like this:

    <connectionStrings>
    <remove name="umbracoDbDSN" />
    <add name="umbracoDbDSN" connectionString="server=YOURSERVER;database=YOURDB;user id=YOURUSER;password='YOURPWD'" providerName="System.Data.SqlClient" />
    <!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. -->
  </connectionStrings>

    Then just copy and paste the connectionString property to your tool.

    Hope this helps.

    /Michaël

    Copy Link
  • Rayyan 46 posts 238 karma points
    Oct 13, 2017 @ 08:05
    Rayyan
    0

    Thanks Michael for your help, I have tried that already but does not work. Here's my connection string;

    <connectionStrings>
        <remove name="umbracoDbDSN" />
        <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />
        <!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. -->
    </connectionStrings>

    First i got this error (Keyword not supported: 'flush interval'.) so I have removed the (flush interval') and added (Persist Security Info=False;), but couldn't make the connection.

    I used this:

    Data Source=umbraco.sdf;Persist Security Info=False;

    And this:

    Data Source=C:\Umbraco.sdf;Persist Security Info=False;

    Any idea please, Thank you

    Copy Link
  • Michaël Vanbrabandt 863 posts 3343 karma points c-trib
    Oct 13, 2017 @ 08:13
    Michaël Vanbrabandt
    0

    Hmmm you are using the SQL CE which is a file, I guess that is your issue.

    Are you sure that the BigRunner tool can work with SQL CE?

    /Michaël

    Copy Link
  • Michaël Vanbrabandt 863 posts 3343 karma points c-trib
    Oct 13, 2017 @ 08:44
    Michaël Vanbrabandt
    1

    Rayyan,

    from what I can see in the docs of the BigRunner Tool, it will only work with a SQL Server instance.

    /Michaël

    Copy Link
  • Rayyan 46 posts 238 karma points
    Oct 13, 2017 @ 09:03
    Rayyan
    0

    Thanks Meesh! Do you know any alternative tools to execute big script?

    Copy Link
  • Michaël Vanbrabandt 863 posts 3343 karma points c-trib
    Oct 13, 2017 @ 09:08
    Michaël Vanbrabandt
    0

    Which work using SQL CE? Hmm not directly, maybe you can convert your SQL CE to a SQL Server instance?

    /Michaël

    Copy Link
  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    Oct 13, 2017 @ 10:03
    Alex Skrypnyk
    1

    Hi Guys

    You can use "SqlCeToolbox" for moving database from MSSQL to SQLCE or back:

    https://github.com/ErikEJ/SqlCeToolbox

    Thanks,

    Alex

    Copy Link
  • Rayyan 46 posts 238 karma points
    Oct 13, 2017 @ 18:01
    Rayyan
    0

    Thank you guys, I think I will remain using (Compact View).

    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