Transfer SQL 2005 Express database to SQL 2005

Discussion in 'Databases' started by paihung, Nov 27, 2005.

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

    I am planning to create a database with SQL 2005 Express on my local PC, do some testing/verification on it, and then"transfer"this tested database toDiscountASP.NET's SQL 2005 server. Is this supported? If yes, how should I do it?

    Thanks,
    Pai-Hung
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    No. THis is not supported yet. MS is supposed to come out with a tool that migrate SQL Express to SQL 2k or 2k5 but the delivery is delayed.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. So basically 2K5 Express database isincompatible with regular 2K5 database?
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    Not necessarily. It just that transferring the schema and data is not a very seamlesss process.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
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