Post reply

moving a database from SQL Server Express to SQL Server 2005

  • December 19, 2007 at 12:27 pm

    #127365

    Hi All,

    I have developed an ASP.NET application that is using SQL Server Express as its datastore (on my dev box). 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 2:49 pm

    #761597

    Your other option is to perform a backup of the database and restore on the production server. Detaching/Attaching is usually faster and just as reliable. Keep in mind that you will take the database offline when detaching, so no one can access the database.

    Make sure you do not forget to move your user accounts over.


    My blog: http://jahaines.blogspot.com

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

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