Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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 ?
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.
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.
Hi again Siva,
I also think this could be useful http://erikej.blogspot.dk/2012/02/migrating-databases-between-sql-server.html
Use Lee's package, just run it locallaly, then migrate your local SQL Server to your web (db) server
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)
<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. -->
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>
I am not able to establish connection between umbraco and sql server r2? i tried with above information.but no success.
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>
I am using sql server r2 edition over windows authentication?
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"/>
It seems like Anthony get it to work with 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.
I searching for the answer for this and did not find anywhere. Please anyone answer :(
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted