What is it you are trying to do? I'll tell you what I think it sounds like and you can tell me how wrong or right I am. It sounds like you've perhaps built a system you're happy with in the local SQLce that comes bundled with Umbraco and you want to migrate that over to an external database.
If this is something similar to your scenario, there is a really handy plugin for Visual Studio that allows you to manipulate .sdf databases.
Using this plugin, you will be able to export an executable query of both the schema and existing data. Then you will be able to construct this in whatever database you like. Just remember to update your ConnectionString in web.config.
Restore umbracoDbDSN from?
Where do I get umbracoDbDSN to restore in separate database?
Hi kowshik,
What is it you are trying to do? I'll tell you what I think it sounds like and you can tell me how wrong or right I am. It sounds like you've perhaps built a system you're happy with in the local SQLce that comes bundled with Umbraco and you want to migrate that over to an external database.
If this is something similar to your scenario, there is a really handy plugin for Visual Studio that allows you to manipulate
.sdf
databases.Using this plugin, you will be able to export an executable query of both the schema and existing data. Then you will be able to construct this in whatever database you like. Just remember to update your ConnectionString in
web.config
.Hi Rhys,
Thank you for the reply :)
That did not work, click the below URL and we are building it new.
https://our.umbraco.org/forum/using-umbraco-and-getting-started//85400-connection-string-did-not-restore-the-developed-site
Regards, Kowshik
is working on a reply...