I am running umbraco version 7.8.1. When i installed umbraco , it did not ask any database,
username and password. I checked web.confi file , it has written the following:
connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;"
providerName="System.Data.SqlServerCe.4.0"
Because why i am asking this one , i am making website in local machine, after i want to move
all files to live server. What can i do database. Is it ok ? shall i write same connection string.
If you don't choose to use another database and setup a connection string for the desired database during the install process Umbraco will use the SQL CE database, which is an embedded database that you can find in the /App_Data/Umbraco.sdf
Then you can open your Umbraco folder within webmatrix and go to the database panel in the lower left corner - Once you're in the database section there should be a "migrate" ribbon in the top bar somewhere. I hope this makes sense - Otherwise I'll see if I can share some screendumps when I get home from work.
Database
Hi,
I am running umbraco version 7.8.1. When i installed umbraco , it did not ask any database, username and password. I checked web.confi file , it has written the following: connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0"
Because why i am asking this one , i am making website in local machine, after i want to move all files to live server. What can i do database. Is it ok ? shall i write same connection string.
Hi Malar
If you don't choose to use another database and setup a connection string for the desired database during the install process Umbraco will use the SQL CE database, which is an embedded database that you can find in the /App_Data/Umbraco.sdf
You can migrate this database to a MSSQL server by following the steps in this guide https://msdn.microsoft.com/en-us/library/gg609538(v=vs.100).aspx - (I have not tried this myself though) - I usually use Webmatrix to do the migration. Webmatrix is however no longer actively supported by Microsoft but you should be able to download it from https://go.microsoft.com/fwlink/?LinkID=286266
Then you can open your Umbraco folder within webmatrix and go to the database panel in the lower left corner - Once you're in the database section there should be a "migrate" ribbon in the top bar somewhere. I hope this makes sense - Otherwise I'll see if I can share some screendumps when I get home from work.
EDIT: Maybe it's even better to follow along this guide? http://www.geektantra.com/2012/10/umbraco-deployment-exporting-ms-sql-ce-database-to-ms-sql-server-express/ - I realise the post is rather old but the migration process should be the same I guess. Also this tool might be of use https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox
/Jan
Hi Jan,
Thank you for your replay. I can check .
is working on a reply...