P2003 database migration, MSDE to SQL2005

B

Ben Howard

Any clues on the steps for migraiting current project (not concerned about
WSS data) from MSDE to a SQL2005 database. The PS2003 server will remain
in-situ, it's just the back end that is changing.

Does SQL come with a wizard to migrate from MSDE to SQL. Assuming it does,
then I'd need to add the relevant user accounts (MSProjectUser etc) to the
SQL database, and then use conninfo or editsite to set PS2003 to look at the
correct database. Is it really that simple, or am I missing somethings (very
likely).

I can test this from MSDE to SQL2000 and then upgrade to SQL2005, but I
suspect on customer site will have to migrate directly from MSDE to SQL2005.

All thoughts/comments and help appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PS2007 migration 0
PS 2003 - restore WSS 2.0/Project Database on new server 0
Project Professinal connection problem after changing Project Server2003 database 3
migrating 2003 to 2007 1
OWC-XML Structure migration issues SQL2005 1
SQL2005 to SQL2000 4
SQL Authentication may fail when migrating from SQL 2000 to SQL 20 0
How to Install Project 2003 SRV with MSDE(without SQL) 5

Top