MSDE to SQL7 to Express?? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

MSDE (2000)

MSDE to SQL7 to Express??

Author

Topic

TimTyler
Starting Member

4 Posts

Posted - 2005-02-16 : 19:41:50

So back in 99 I installed O'Reilly's WebBoard forum software for a client on an NT Server. That software came bundled with MSDE for the db.

In 2000 we upgraded MSDE on that server to SQL7.

Now I need to migrate the WebBoard db from that server onto a new speedy Server2003.

Do you know if it's possible to move the WebBoard db and install it under SQL Server 2005 Express? I wonder if I should install Express on the old box and THEN move it, or if Express will even work on the old server. Hmmmm.

Tim Tyler
Olympia, WA
timtyler.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-16 : 19:46:17

SQL Server 2005 Express is in Beta right now. I wouldn't be moving production databases over to it until it is RTMed later this year. A database in 2000 can be upgraded to 2005 via the backup/restore, sp_detach_db/sp_attach_db, upgrade wizard, or DTS. Whether or not the application will work with the upgrade database, well that's up to you to find out during testing of it.

If I were you, I would remove your phone number from your post.

Tara