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-10-05 : 04:41:37
|
| Hi Folks,I want to migrate from Sql Server 2000 enterprise to Sql Server 2008 express version. Could someone guide me step by step.Thanx |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-05 : 04:58:22
|
| Enterprise to express ?I would advice you to check the features supported by enterprise that are not available in express, ie if you have jobs, SSIS (which was DTS in 2000) etc express doesnt support them.If not, then you can simply backup and restore or attach and detach. |
 |
|
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-10-05 : 09:35:04
|
| Thank you afrika.Shall revert in case of problem |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-10-05 : 10:15:39
|
| I would say that you should re-think the version that you are migrating too |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-05 : 17:02:02
|
I agree with Neil,Express limits your DB memory and storage usage, ... amongst many other things.  |
|
|
|
|
|
|
Migrating from sql server 2000 to 2008