I set up an environment for a developer with Windows server 2012, MySQL 5, IIS and ftp access and so on. We have a staging environment apart from the server environment. If I recall correctly, the dev was given the http://umbracosite url where the installer was waiting for him to proceed, and credentials for MySQL.
Somehow, it appears that he managed to avoid using MySQL at all; there is no other SQL server that I can find, and yet Umbraco seems to be functioning. There are two umbraco related databases in MySQL but they are completely empty with no tables. There is an AppData/umbraco.sdf that's about 4mb.
Where are the config files that configure database for Umbraco? This is not a WebMatrix install. I would like to figure out how Umbraco is accessing database and import the data into MySQL and reconfigure Umbraco to point to the new databases.
Check the web.config and look at connection string. Maybe using the umbraco ce database. umbraco.sdf. you can use mysql but it will perform great with Microsoft SQLExpress which is free. Also to import the database you can use web matrix to an SQLexpress install. never done it to Mysql. I could but why?
I think the developer has probably just hit the green "install" button and then Umbraco is installed with a predefined starter kit (Fanoe starter kit) based on CE SQL.
If one hits the "Customize" button in the install process one needs to make some choices regarding databases and whether to use a starter kit or not. During the DB selection it's stille possible to select CE SQL though but from your description above I'm 99% confident that he must have just hit the install button.
So you should probably do a migration from CE SQL to MySQL - Webmatrix might be useful for doing that.
How do I check what db Umbraco is using
I set up an environment for a developer with Windows server 2012, MySQL 5, IIS and ftp access and so on. We have a staging environment apart from the server environment. If I recall correctly, the dev was given the http://umbracosite url where the installer was waiting for him to proceed, and credentials for MySQL.
Somehow, it appears that he managed to avoid using MySQL at all; there is no other SQL server that I can find, and yet Umbraco seems to be functioning. There are two umbraco related databases in MySQL but they are completely empty with no tables. There is an AppData/umbraco.sdf that's about 4mb.
Where are the config files that configure database for Umbraco? This is not a WebMatrix install. I would like to figure out how Umbraco is accessing database and import the data into MySQL and reconfigure Umbraco to point to the new databases.
Thanks for any help,
Check the web.config and look at connection string. Maybe using the umbraco ce database. umbraco.sdf. you can use mysql but it will perform great with Microsoft SQLExpress which is free. Also to import the database you can use web matrix to an SQLexpress install. never done it to Mysql. I could but why?
Best of luck
Keith
Hi
Open the web.config file and search for connection string.
See the screen shot
hope this help
I think the developer has probably just hit the green "install" button and then Umbraco is installed with a predefined starter kit (Fanoe starter kit) based on CE SQL.
If one hits the "Customize" button in the install process one needs to make some choices regarding databases and whether to use a starter kit or not. During the DB selection it's stille possible to select CE SQL though but from your description above I'm 99% confident that he must have just hit the install button.
So you should probably do a migration from CE SQL to MySQL - Webmatrix might be useful for doing that.
Hope this helps.
/Jan
hi jan,
how to migrate sql ce to ms sql server ? any tools available?
Thanks in advance Kajul
Hi
This Visual Studio extension is doing a great job - https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox#review-details
is working on a reply...