Migrating database from development server to hosted server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • spudse
    New Member
    • Jan 2008
    • 11

    #1

    Migrating database from development server to hosted server

    Hello,
    I have created a database on my home development server (Microsoft SQL Server 2005 Express). Now I finally found a hoster that fits my needs and I would like to migrate my database to this hosted SQL Server.

    The database contains:
    - Tables
    - Data inside tables
    - Views
    - Stored procedures

    I can connect to this server remotely. However I don't have file access so I can't just restore backup (forcing the recreation of the structure). I thought about using the script export function, but this doesn't include the data that is in my tables.

    What is the most efficient way to migrate my database?
  • spudse
    New Member
    • Jan 2008
    • 11

    #2
    Ok, I was one google search away from my answer :)

    SQL Server Hosting Toolkit

    Edit: It's really a great tool!

    Comment

    Working...