Database Migration

Discussion in 'Databases' started by darena1009, Sep 28, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. darena1009

    darena1009

    I am new to web hosting. What is the most common way to migrate a database to the web site? I keep a local copy for testing. When it is ok, I would like to copy it up. Is the detach/attach the best scenario? Doing this takes the web site down.
     
    darena1009, Sep 28, 2008
    #1
  2. wisemx

    wisemx

    Hi,
    Personally I like the Import/Export tasks method.
    I've used it many times here for complex DBs.

    Do you have a local SQL engine installed?
    Salute,
    Mark
     
    wisemx, Sep 28, 2008
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    In any case, when you change your database, you should disable your site. The attach process should be fairly quick (unless your DB is huge).


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Sep 29, 2008
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page