Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Roman Mellenberger 14 posts 32 karma points
    Apr 03, 2013 @ 11:58
    Roman Mellenberger
    0

    Deploy Database best practice

    Hi,

    I want to deploy my local running Umbraco site (v6) on a hosting provider. I have access to the SQL Server but there is no way to do a db restore. I have to deploy the database using ddl or SQL Script.

    Can someone tell me how to do that?

    I was testing with a ddl but lost all ID's and triggers...

    Thanks

    Roman

    Copy Link
  • Rich Green 2246 posts 4008 karma points
    Apr 03, 2013 @ 12:01
    Rich Green
    0

    Hey Roman,

    You can script out your whole local db using SQL Management Server, right click your DB and choose create scripts.

    Remember to include scripting data (as well as indexes etc. but I'm sure this is on by default).

    Rich

    Copy Link
  • Roman Mellenberger 14 posts 32 karma points
    Apr 03, 2013 @ 13:55
    Roman Mellenberger
    0

    Hi Rich,

    Thanks for the reply. It's not this simple because some of the scripted settings (especially database settings) are not supported by the provider. After deleting these the script ran successfully and the website is online now.

    Thanks!

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft