[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SMS 2003 Software Collection Migration to SCCM 2007

Posted on 2010-08-23
6
Medium Priority
?
1,780 Views
Last Modified: 2013-11-21
Hi All,

We've currently installed a fresh install of SCCM 2007 SP2 R2 in our domain. We decided not to go with the migration option from SMS because this SCCM is part of a new domain infrastucture we're setting up at our company.

I wanted to know if there is any way to export our software distribution collections from SMS and import them into SCCM. I've heard this can be done via a SQL query.

Any ideas?

Many thanks.
0
Comment
Question by:malkaj01
[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 Comments
 
LVL 1

Accepted Solution

by:
benny111 earned 1000 total points
ID: 33499802
Check out this article on side by side migration of SMS 2003 to SCCM 2007.

Also a step by step process here.

Hope these guides help.
0
 
LVL 6

Expert Comment

by:Exemplar
ID: 33501059
Hello malkaj01!

You can accomplish this be utilizing the Export Object wizard.  To do this, simply right-click on the specific Collection that you want to export and choose Export Object.  Follow the wizard.  This creates a MOF file.  You can then take that MOF file to the new site server.  You can right-click on the site database and then use the Import Object wizard which allows you to copy the MOF file to the new site server.

Please reference this MS TechNet article for specifics:
http://technet.microsoft.com/en-us/library/cc181056.aspx#EBAA

Additionally, if your organization has a Microsoft TAM, you may be able to request a tool known as CopySCCMObj.  This tool can move Collections from site to site as well.

/cheers
0
 
LVL 6

Author Comment

by:malkaj01
ID: 33502079
Sent an email out to our TAM. Keep you posted.
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
LVL 31

Assisted Solution

by:merowinger
merowinger earned 1000 total points
ID: 33541515
0
 
LVL 6

Author Comment

by:malkaj01
ID: 33546717
Exemplar: Our Microsoft TAM just wrote back. CopySCCMObj is an internal MS tool and is not released out to any company unless your involved in a MS migration project done by MS.

merowinger: Is this R2 compatible? I'm setting up a test domain right now to see how the process goes. Will the script still leave everything intact on our SMS site?

0
 
LVL 31

Expert Comment

by:merowinger
ID: 33549062
I did not try it with SCCM R2, but it should work on almost each version independed if its SMS or SCCM as the same WMI Classes are used.
The script is just query the old site for information and creates the collection on the new site.
Your correct, first run it on a test environment before running it on your production.

I've already used CopySCCMObj. It's really a cool tool, the problem is that it was written by a MS emplyee in his private time and so there's no support on the tool!
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

656 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