Solved

Can I import database from a SharePoint Services 3.0 to an existing SQL 2005 SP4 database?

Posted on 2011-03-15
8
776 Views
Last Modified: 2012-06-27
Hi, I am trying to figure out how I can import or merge a database from a SharePoint Services 3.0 server to an existing SQL Server 2005 SP4 database, so SharePoint Foundation 2010 can use it.

What is the process to accomplish this?

Thanks in advance.
0
Comment
Question by:rsnellman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2
8 Comments
 

Author Comment

by:rsnellman
ID: 35142220
I can attach the WSS database, but when I view the content database section in SharePoint 2010, I add the content database pointing to the database on the SQL Server 2005, the Current # of Site Collections is 0.

I am no SQL or SharePoint expert, so I know this is why it is probably going to sound simple to most.

Just trying to finalize this database migration.

Thanks.
0
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 500 total points
ID: 35142322
you need to upgrade the wss 3.0 data first, using a supported upgrade path.  then export your data, or move it.

here is a summary of the process & options:
http://mosshowto.blogspot.com/2010/06/migrating-to-sharepoint-2010.html
0
 

Author Comment

by:rsnellman
ID: 35142408
So, I would need to have a second box running the the SharePoint Services 3.0 database and then do an in-place upgrade to SharePoint Foundation 2010?

This will work on a Server 2003 R2 x32 machine?

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 35142915
that is method 2.

method 1 listed in the article is for attaching the database method.
0
 

Author Comment

by:rsnellman
ID: 35148477
I have attempted method 1 with little success.  Let me explain further.
------------------------------------------------------------------------------------------------------------------------
Here is my setup:
Server1 = Server 2003 R2 x32 running Sharepoint Services 3.0
Server2 = Server 2008 R2 running SQL Server 2005 x64 SP4
Server3 = Server 2008 R2 running Sharepoint Foundation 2010
-------------------------------------------------------------------------------------------------------------------------

I copied the WSS_Content.mdf & .ldf files from Server1 to Server2 and then attached the database within SQL Server Management Studio console.  I wanted it to attach as WSS_Content database, it attached as a different database name.

Then in SharePoint 2010 Central Administration console on Server3, I navigated to Application Management \ Manage content databases.  Then I added a content database, with the name of the database attached on Server2.

After the adding the content database on Server3, I notice that the WSS_Content (currently created during the SharePoint Foundation installation) displays 1 Current Number of Site Collections.  The newly added database under a different name is displaying 0 Current Number of Site Collections.

So, either I need to some how make the different database active or something or need to merge this database with the current (working) WSS_Content database.

Any further assistance would be greatly appreciated.
0
 

Author Comment

by:rsnellman
ID: 35148484
Correction, I meant I have attempted method 2.
0
 

Author Comment

by:rsnellman
ID: 35148490
Correction, correction...I was right the first time.  I meant method 1.

Sorry, it is been a very very crazy week so far.
0
 

Author Comment

by:rsnellman
ID: 35149060
It might help with I explain the database that Server1 running SharePoint Services 3.0 is using.  It is using the built-in database engine, which I believe is a SQL Server 2005 Express or Lite...something like that.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question