[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2011-03-15
8
Medium Priority
?
788 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 44

Accepted Solution

by:
zephyr_hex (Megan) earned 2000 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 44

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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

650 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