Announcement

Collapse
No announcement yet.

Run SQL2000 DB on Express 2008

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Run SQL2000 DB on Express 2008

    I have a server which I inherited running Server 2003/MSSQL 2000 Enterprise. This is completely unnecessary as it is only accessed in a small office of 10 workstations and gets simple data requests from a website.

    I want to replace the server and i'm torn between imaging the current server onto the new machine or upgrading to Server 2008 and MSSQL 2008 express.

    Is it possible to export my database from SQL 2000 enterprise and import it into SQL Express 2008 R2 and run in compatibility mode?

    Thanks for any insight you can provide.

    SK

  • #2
    Re: Run SQL2000 DB on Express 2008

    this any use ?
    http://blogs.msdn.com/b/zxue/archive...rver-2008.aspx
    Please do show your appreciation to those who assist you by leaving Rep Point https://www.petri.com/forums/core/im.../icon_beer.gif

    Comment

    Working...
    X