Request for guide to migrate from MSDE to SQL Express 2005 or 2008

[laichenkang]

Any pointers?

[Andrea Montanari]

hi,

Post by laichenkang
Any pointers?

not that I'm aware of....
but you can have a look at the Microsoft SQL Server 2008 Upgrade Advisor,
http://www.microsoft.com/downloads/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en
executing that tool you can find "stuffs" that are no longer in order with
the new edition of the engine, like deprecated JOIN styles and the like..
this will enable you to modify and test your current platform in the SQL
Server 2000 instance as well.. you can read further hints at
http://msdn.microsoft.com/en-us/library/bb677622.aspx..

[laichenkang]

I want to move from Machine A with MSDE to Machine B with SQL Express
2005.

Should I:
a. Move MSDE from Machine A to B. Then perform an in-place upgrade to
SQL Express 2005
b. Perform an in-place on MSDE then move to Machine B?

[Andrea Montanari]

hi,

Post by laichenkang
I want to move from Machine A with MSDE to Machine B with SQL Express
2005.
a. Move MSDE from Machine A to B. Then perform an in-place upgrade to
SQL Express 2005
b. Perform an in-place on MSDE then move to Machine B?

I'd go for
c. let machine A rest in peace and just install SQLExpress on a clean
machine B..
there you have to generate all required logins, restore (or create for
attach) the MSDE databases and syncronize the SQL Server logins (if any) via
sp_change_users_login system stored procedure..

[William Vaughn (MVP)]

I'm with Andrea on this... You can also detach the MSDE database, copy it to
the new system and reattach. It will convert it to the new server database
type but you'll need to reset the compatibility level once its done.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
[phone] (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

Post by Andrea Montanari
hi,

Post by laichenkang
I want to move from Machine A with MSDE to Machine B with SQL Express
2005.
a. Move MSDE from Machine A to B. Then perform an in-place upgrade to
SQL Express 2005
b. Perform an in-place on MSDE then move to Machine B?

I'd go for
c. let machine A rest in peace and just install SQLExpress on a clean
machine B..
there you have to generate all required logins, restore (or create for
attach) the MSDE databases and syncronize the SQL Server logins (if any)
via sp_change_users_login system stored procedure..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply