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.
| Author |
Topic |
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
 Posted - 2008-09-27 : 22:57:40
|
| Hi Everyone,I am running Sql Server 2000 on Windows Server 2003 SP2. I want to know how to migrate to SQL Server 2008 Express keeping my database intactThanx |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-28 : 04:22:03
|
2008 Express doesnt have the SQL Agent and dont think it supports jobs and a few other features.We just migrated a few of our databases "2005 though", to 2008 Web edition. I just migrating a few of the 2000 databases today. All we did was a backup and a restore. You can also detach and attach2008 Seems really interesting, with intellisense, a lot of .net features, which makes if even more fun. And Security. Still testing though  |
 |
|
|
|
|
|
Migrate to SQL Server 2008 : How to