MS SQL Standard to Express Migration

Can anyone tell me the steps of moving from SQL Standard 2000 to Express 2005/ 2008 on the same machine?
tru504187211Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Steps below:

* Take a backup of all user databases and system databases
* Transfer logins script as per
http://support.microsoft.com/kb/246133
* Uninstall SQL Server 2000
* Intall SQL Server 2005 / 2008 Express
* Restore User database and system databases backups
* Run logins script created earlier.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tru504187211Author Commented:
Is it possible to stop SQL Server before installing SQL Express?  (just to make sure a rollback could happen if something goes wrong)
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
If you prefer that way, then your SQL Express instance installation should be done as a named instance.
Difference being Default instance would be referred as Servername and named instance would be servername\instancename.
Then you need to change the servername in all the applications that uses your database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.