HELP!!! Still testing the migration process from WSS 3.0 to SharePoint Foundation 2010.

Hi, I am not sure if this is a problem, but here is the scenario.

I am migrating from WSS 3.0 (default install, meaning it is using SQL 2005 EE locally) on Server 2003 R2 x32 to SharePoint Foundation 2010 x64 on Server 2008 R2 with remote database SQL Server 2005 x64.

Server1: Server 2003 R2 x32 Standard Edition / WSS 3.0 default install (database content name is "WSS_Content.mdf")

Server2: Server 2008 R2 Standard Edition / SPF 2010 x64 / database content name is "SharePointFoundation2010.mdf" & resides on a remote server running Server 2008 R2 & SQL Server 2005 x64 SP4.

My question/concern is when I perform a back up of the WSS_Content (WSS 3.0) database and move it over to the new server running SQL 2005 x64 SP4 and attach it, will it need to the same name as the current database that I named during the SPF2010 Farm installation setup (SharePointFoundation2010.mdf)?  Or will I be able to restore the WSS_Content to this already existing mdf file somehow?  If I can restore it then what is the process of doing so?

If not, would I just be better off, uninstalling SharePointFoundation2010 and reinstalling it and using the default configuration name (SharePoint_Config) like the old WSS 3.0 has for it's?

Or maybe a better way to describe my concern is under SPF 2010 Web Applications section, the following:

- SharePoint - 80
- SharePoint Central Administration v4

Well, the SharePoint - 80 usually points to the "SharePoint_Config", but the Server2 configuration I installed was customized, I guess, because the SharePoint - 80 is pointing to the "SharePointFoundation2010" instead of the default "SharePoint_Config".  Will this be a problem with my migration of the database content (WSS_Content.mdf)?

Hopefully I am making sense, because I am not sure if I understand it myself.  LOL

Thanks in advance.
rsnellmanIT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

rsnellmanIT ManagerAuthor Commented:
What I was referring to earlier in SharePoint Foundation 2010 is to find Central Administration / Web Application / Servers in Farm...

Configuration database name:  "SharePoint_Config"   is the default name, but I customized it during setup and called it "SharePointFoundation2010".
Justin SmithSr. System EngineerCommented:
no the databases don't have to be the same name.
rsnellmanIT ManagerAuthor Commented:
OK, so how do I proceed in connecting the database (WSS_Content) from the WSS 3.0 server to the new server running SQL Server 2005 SP4 with SharePoint Foundation 2010?

Would I perform a restore from SQL Server 2005 SP4 on the new server overwriting the current database for SharePoint Foundation 2010?

Or another way?
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Justin SmithSr. System EngineerCommented:
When you deployed Foundation, did you do a simple stand alone install?  Or did you do an advanced - complete install?

I'm guessing the current WSS_Content in your Foundation was deployed as part of your install, and doesn't have any real content.  If so, I would delete the web application that was created by the wizard in Foundation and choose to delete the data.  This will remove the wss_content db from your Foundation server.  

Then you can do the restore.  Then you'll create your 2010 web application and specify a temporary database name (like wss_content_temp).  After your web app is created, go into Content Databases in Central Admin, and remove the _temp database.  Then attach the wss_content database, which will upgrade it.

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
rsnellmanIT ManagerAuthor Commented:
Yes, I created a general WSS_Content database with my Foundation installation.  So, it contains nothing of importants at this time.

Thanks, I will try this and let you know how it turns out.

Thanks again.
Justin SmithSr. System EngineerCommented:
Just an FYI, if you ever need remote assistance, I'm available.
rsnellmanIT ManagerAuthor Commented:
Thanks.  I appreciate that.  One last thing, how do I attach the wss_content database to the SharePoint Foundation web application?

Do I have to use the command prompt with "stsadm -o addcontentdb" command?

Also, why did I need to delete the current wss_content database on Foundation & from SQL Server 2005 when deleting the current web application then create a wss_content_temp database when creating a new web application just to delete the wss_content_temp database?

Sorry, I just don't understand why.

rsnellmanIT ManagerAuthor Commented:
OK, I am missing something, because I cannot attach the content database to SharePoint Foundation.

Here is what I am trying:

Within SharePoint Foundation 2010 Management Shell:

stsadm -o addcontentdb WSS_Content.mdf

But it comes back with a command line error.  No other details, just an error.

What am I missing?

I have never attached a content database in SharePoint before.  So, I am sure it is something I am doing wrong.

Justin SmithSr. System EngineerCommented:
You have to specify a web application in your stsadm command.  Also, don't add the .mdf to the end of the name.

You delete the current wss_content database in Foundation because it's garbage.  Also, if that database already exists, you aren't gonna be able to restore the database from WSS if it's also named wss_content.  

When you create your new web app, you use a dummy name with _temp at the end, so you know you can delete it.  Then you attach the restored wss_content database to the Web app through the STS command.  This will upgrade the database.  You can then detach the dummy one and delete it.
rsnellmanIT ManagerAuthor Commented:
Oh, OK.  Opps.  I already deleted the dummy temp database and am now trying to attach/upgrade the real database.  It is already in SQL Server 2005 x64, just need to get Foundation to see it.

Gotcha, makes more sense now.

I really appreciate all your help with this.  I have been trying off and on for over a year to get this migration completed.  It has been a high priority but then again other fires make it sit on the back burner for sometime.  Now I have time to complete this project and feel that I am very very close to finalizing it.

Thank again.
rsnellmanIT ManagerAuthor Commented:
Awesome.  The test migration worked like a charm.  Now to proceed with the production migration.

Also, how should I proceed if I want to add a ssl cert to the sharepoint site?

Do I do that during the migration or after I have the migration completed successfully?

Thanks again.
rsnellmanIT ManagerAuthor Commented:
I am sorry, if I am getting on another topic and should start another question thread then I can do that too.  I just trying to ironing this out and be done with this project.
Justin SmithSr. System EngineerCommented:
Wait till afte the migration and after everything is up and running on the new platform.
rsnellmanIT ManagerAuthor Commented:
OK.  Thanks.  You have been a life saver.
Justin SmithSr. System EngineerCommented:
LOL.  Glad it worked out.
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 2005

From novice to tech pro — start learning today.