Solved

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

Posted on 2011-03-15
8
768 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
  • 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 42

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 42

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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 procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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…

773 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