SMS 2003 Software Collection Migration to SCCM 2007

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.
Who is Participating?
benny111Connect With a Mentor Commented:
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.
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:

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.

malkaj01Author Commented:
Sent an email out to our TAM. Keep you posted.
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.

merowingerConnect With a Mentor Commented:
malkaj01Author Commented:
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?

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!
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.