How to deploy Umbraco local site to server?

Question

I don't know how can I deploy my local Umbraco 7.2 local website to a normal server (Windows 2012 VPS). I know I need to copy all files to the server, but I can't figure out how can I copy the database. I download an SQL Management Studio 2012, but I don't know the access details, because when I installed the site to my localhost, the installer didn't ask me. Maybe on thing, as I remember, the DB type. It was SQL CE.

Does anybody know how can I access to the local and server database? Whats is Umbraco database name? Is there any else configuration?

Maybe an easier option to deploy?

score 0 · Accepted Answer · edited May 23 '17 at 12:26

You can:

Open the database \App_Data\Umbraco.sdf see How do you open an SDF file (SQL Server Compact Edition)? (it is not in new SQL Management Studio versions) and do your database things to deploy.
Copy the SQL CE default \App_Data\Umbraco.sdf
Create a package
Using tools like Courier

And see the web.config for your connectionString:

  <connectionStrings>
    <remove name="umbracoDbDSN" />
    <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />
    <!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. -->
  </connectionStrings>

Thanks. I just noticed the Umbraco.sdf file as well. I didn't tested yet, because I would like to move from local DB to SQL Express. — levipadre, Jun 02 '15 at 13:26

How to deploy Umbraco local site to server?

1 Answers1