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

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.
rsnellmanIT ManagerAsked:
Who is Participating?
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
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
 
rsnellmanIT ManagerAuthor Commented:
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
 
rsnellmanIT ManagerAuthor Commented:
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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
zephyr_hex (Megan)DeveloperCommented:
that is method 2.

method 1 listed in the article is for attaching the database method.
0
 
rsnellmanIT ManagerAuthor Commented:
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
 
rsnellmanIT ManagerAuthor Commented:
Correction, I meant I have attempted method 2.
0
 
rsnellmanIT ManagerAuthor Commented:
Correction, correction...I was right the first time.  I meant method 1.

Sorry, it is been a very very crazy week so far.
0
 
rsnellmanIT ManagerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.