umbraco local connection string path

Press Ctrl / CMD + C to copy this to your clipboard.

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

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?

Thank you,

Copy Link

Michaël Vanbrabandt 863 posts 3348 karma points c-trib

Oct 13, 2017 @ 07:44

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

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 3348 karma points c-trib

Oct 13, 2017 @ 08:13

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 3348 karma points c-trib

Oct 13, 2017 @ 08:44

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

0

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

Copy Link
Michaël Vanbrabandt 863 posts 3348 karma points c-trib

Oct 13, 2017 @ 09:08

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 6163 posts 24143 karma points MVP 8x admin c-trib

Oct 13, 2017 @ 10:03

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

0

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

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?