DOWNGRADE SQL Express 2005 to MSDE

• sabin.johnson

  Newbie

  Points: 7

  More actions

  January 16, 2009 at 8:47 am

  #204147

  I have a new client who's previous consultant upgraded one of their databases from MSDE to SQL Express. This has caused some problems within the application this database is the backend for.

  I need to find a way to downgrade the SQL Express 2005 to the old MSDE. Is this possible?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  January 16, 2009 at 8:50 am

  #928232

  Script the db on 2005, recreate it on 2000 (make sure evertyhing still works in the sps, views, etc).

  Import the data from the old server to the new one.

  There's nothing out of the box that will do that for you.