Solved

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

Posted on 2011-03-15
8
773 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 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
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
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 Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

735 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