Hi Siva,

I´m thinking that you should have a look on this package. As I can see from the support forum, right now it will only work with full trust. The post about this is from the 18th of April 2013.

http://our.umbraco.org/projects/backoffice-extensions/export-sql-server-compact

If you can´t get the package to work on your installation you could try this. http://sqlcetoolbox.codeplex.com/

Or you could try ask Lee for support in here; http://our.umbraco.org/projects/backoffice-extensions/export-sql-server-compact/export-sqlce-feedback

I hope this package can help you out.

/Dennis

Hi again Siva,

I also think this could be useful http://erikej.blogspot.dk/2012/02/migrating-databases-between-sql-server.html

/Dennis

Use Lee's package, just run it locallaly, then migrate your local SQL Server to your web (db) server

Hi All,

      Thanks for your replies.it worked.now i moved the data to sql server r2.But now how to connect umbraco to sql server r2  instead of sql compact edition.

Just change your connection string in web.config to (with your details)

  <connectionStrings>

    <remove name="umbracoDbDSN" />

    <add name="umbracoDbDSN" connectionString="Server=.\SQLEXPRESS;Database=Your_Database_Name;user id= Your_Userame;password= Your_Password" providerName="System.Data.SqlClient" />

  <!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. -->

  </connectionStrings>

Hi Siva,

In your WebConfig file you need to find the lines and fill in the information. So I think you should be good. If this line is not in your WebConfig, then just add it.

<appSettings>
        <addkey="umbracoDbDSN"value="server=yourservername\sql2008r2;database=databasename;user id=xxx;password=xxxx"/>
</appSettings>

/Dennis

Hi,

  I am not able to establish connection between umbraco and sql server r2? i tried with above information.but no success.

Hi Siva,

Did you try with Rich solution also. Maybe you´re using an express version of SQL server.

<appSettings>
        <add name="umbracoDbDSN" connectionString="Server=.\SQLEXPRESS;Database=Your_Database_Name;user id= Your_Userame;password= Your_Password" providerName="System.Data.SqlClient" />
</appSettings>

/Dennis

hi,

   I am using sql server r2 edition over windows authentication?

Hi,

I am using sql server r2 edition over windows authentication and local umbraco server version is 6.1.2 and i am using this connection string.still i am getting error.

 <add name="umbracoDbDSN" connectionString="server=square-16\sql2008r2;database=master;Trusted_Connection=False"/>

Hi Siva,

It seems like Anthony get it to work with windows authentication.

http://our.umbraco.org/forum/getting-started/installing-umbraco/16501-using-a-connectionstring-for-windows-authentication

Maby you could try to setup the connection string after his pattern, and see if this work Or you could ask the question in the topic, or just refer to this post in the other post.

/Dennis

I searching for the answer for this and did not find anywhere. Please anyone answer :(

is working on a reply...