Click here to Skip to main content
13,291,690 members (51,764 online)
Click here to Skip to main content
Add your own
alternative version

Stats

4K views
2 bookmarked
Posted 11 Oct 2013

How to create Umbraco database on shared hosting.

, 11 Oct 2013
Rate this:
Please Sign up or sign in to vote.
I had to create Umbraco database on my shared hosting (I am using Winhost at the moment) couple of days ago.After checking few examples on

Editorial Note

This articles was originally at wiki.asp.net but has now been given a new home on CodeProject. Editing rights for this article has been set at Bronze or above, so please go in and edit and update this article to keep it fresh and relevant.

I had to create Umbraco database on my shared hosting (I am using Winhost at the moment) couple of days ago.

After checking few examples on Umbraco forum, I came up with my own quick solution which works like a charm.

Here is how I do it, hope it will help you to quickly resolve this issue if you face it.

First I created a blank SQL database on my shared hosting. Then:

I have created DB script from VS 2010.

  1. Open Visual Web Developer Express 2010/VS 2010 Pro
  2. Open Database Explorer (View -> Database Explorer) (in Visual Studio 2010 you will open “Server Explorer”).
  3. The Database Explorer should show up on the right side of the IDE.
  4. Right click Data Connections and select Add Connection.
  5. Enter the server name in the first text box (type the name of your local SQL Server).
  6. Type the name of the database in the database name field and click “OK.”
  7. In Database Explorer you will see your local database.  Right click on it and choose Publish to Provider.

Then:

To generate the script that will create the backup of your database follow the steps listed below.

  1. Click “Next” on the welcome screen of Publishing Wizard.
  2. Insure that your database is selected, check Script all objects in the selected database and click “Next.”
  3. Choose the Script to file option and type the name of the script you will be generating. Click “Next.”
  4. Leave the default Publishing Options and click “Next.”
  5. Click “Finish.”

After that:

  1. Open your database in SQL Server Management Studio 2008.
  2. Click File/Open/File and navigate to the SQL script you just created from your SQL Server.
  3. Input your database login and password from Control Panel
  4. Once the script is opened, navigate to the very top of the page and type:
    • USE [database name] (without the brackets)
    • GO
  5. Click the “Execute” button.

It creates all tables exactly the same as you have in your local DB.

Happy coding!

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

ASP.NET Community
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Group type: Collaborative Group

764 members


You may also be interested in...

Pro
Pro

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.171207.1 | Last Updated 11 Oct 2013
Article Copyright 2013 by ASP.NET Community
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid