Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Moving from SQL Express 2k5 to SQL Server 2k5

    What is the best way to move a SQL Server Express 2k5 database to a SQL Server 2005 (standard) server? Would I simply just detach the database and logs, copy them to the new server, then reattach them? Thanks!

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    It would be better to back up the databases on the Express server then restore them on the standard version.

    Be aware that there are some subtle differences in a few T-SQL instructions and their syntax between the two versions, so carefully check the stored procedures and functions (if any) before validating the migration.

    See also:
    Microsoft SQL Server: SQL Server 2005 Features Comparison

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts