Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • siva kumar 120 posts 209 karma points
    Oct 17, 2013 @ 14:02
    siva kumar
    0

    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 ?

  • Dennis Aaen 4448 posts 17912 karma points admin hq c-trib
    Oct 17, 2013 @ 14:24
    Dennis Aaen
    1

    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

  • Dennis Aaen 4448 posts 17912 karma points admin hq c-trib
    Oct 17, 2013 @ 14:31
    Dennis Aaen
    0

    Hi again Siva,

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

    /Dennis

  • Rich Green 2246 posts 3976 karma points
    Oct 17, 2013 @ 18:00
    Rich Green
    2

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

  • siva kumar 120 posts 209 karma points
    Oct 18, 2013 @ 08:55
    siva kumar
    0

    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.

          

  • Rich Green 2246 posts 3976 karma points
    Oct 18, 2013 @ 09:03
    Rich Green
    1

    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>

  • Dennis Aaen 4448 posts 17912 karma points admin hq c-trib
    Oct 18, 2013 @ 09:12
    Dennis Aaen
    0

    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

  • siva kumar 120 posts 209 karma points
    Oct 18, 2013 @ 12:08
    siva kumar
    0

    Hi,

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

  • Dennis Aaen 4448 posts 17912 karma points admin hq c-trib
    Oct 18, 2013 @ 12:34
    Dennis Aaen
    0

    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

  • siva kumar 120 posts 209 karma points
    Oct 18, 2013 @ 13:24
    siva kumar
    0

    hi,

       I am using sql server r2 edition over windows authentication?

  • siva kumar 120 posts 209 karma points
    Oct 18, 2013 @ 13:38
    siva kumar
    0

    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"/>
    
  • Dennis Aaen 4448 posts 17912 karma points admin hq c-trib
    Oct 18, 2013 @ 14:27
    Dennis Aaen
    0

    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

  • kowshik 20 posts 90 karma points
    May 02, 2017 @ 16:03
    kowshik
    0

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

Please Sign in or register to post replies

Write your reply to:

Draft