Post reply

Best way to move a database from SQL Server Express to SQL Server

  • December 19, 2007 at 12:23 pm

    #180011

    HI All,

    I have developed an ASP.NET application that uses SQL Server Express as its datastore. I need to migrate this app and the database to our live servers. Can you give me some insight into the best way to pack up this SSE database for installation on the SQL Server box? So far, in my reading, it seems like detaching the database, copying the .mdf and .ldf files to the DATA directory of the live box and then attaching would be an effective way to proceed. Is there a better way?

    Thanks so much for any input you can offer!

    Thom Cox

    Lead Web Developer

    Tufts University

  • December 19, 2007 at 12:40 pm

    #761520

    this is a pretty good way. maybe you should consider backup/restore route? this way you don't have to take db offline, though this probably does not matter too much.

    ...and your only reply is slàinte mhath

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply