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.
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.
In yourWebConfigfile youneed to findthelinesand fill inthe information.So Ithink you shouldbe good.Ifthis lineis not in yourWebConfig, then justadd it.
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.
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.
How to migrate from default db to sql server
I am using local umbraco server with default database.now i want to migrate from sqlce to sql server r2 enterprise?how to do it ?
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.
/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.
/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.
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...