locked
SMS 2003 Migration RRS feed

  • Question

  • I have a question......

    I am in process of upgrading my current SMS envi to SCCM 2007 and planning to do it on a new hardware. Currently I am having a Central-Primary and Secondary with SQL DB on both Central and Primary. I am planning to install 2003 on new hardware and do a siterestore and  upgrade to SCCM 2007. So My question is If I copy the DB of Central to new H\W and do a restore, does it restore everything? and what happens to my primary and secondary sites.... I am planning only a single site in 2007.

    Tuesday, January 22, 2013 12:10 PM

Answers

  • No you can’t copy the database to the new server like that. You must use the SMS 2k3 Backup task for each site.  This is where you will be cause yourself a ton of extra work. When you do the restore it MUST be restore to the exact same setup as when it was back up.  Here is a simplified plan of what you need to do.

    SMS2k3 - > SMS2k3

    • Build new server
    • All drives must look the same.
    • SQL must be the same, setup, you can change SQL version but keep in mind that
      • The collation must be the same
      • You must use be a supported version of SQL
    • Windows must be the same, but you can upgrade windows to a supported version (Windows 2003 only?? http://technet.microsoft.com/en-ca/library/cc181628.aspx)
    • Make sure everything is ok before move to next step

    SMS2k3 – CM07

    • Upgrade Server from SMS2k3 – CM07
    • Upgrade Clients
    • Make sure everything is ok before move to next step

    CM07 – CM12

    • Build new server
    • Install Windows 2012
    • Install SQL 2012
    • Install CM12
    • Migrate Packages
    • Remove boundaries form CM07
    • Upgrade Clients

    Without knowing too much about your environment, I would suggest that you create 1 CM12 primary site and maybe a secondary site.

    BTW this is the high level plan for going directly to CM12

    SMS2k3 – CM12

    • Build a new server
    • Install Windows 2012
    • Install SQL 2012
    • Install CM12
    • Migrate Packages – Export / Import (there are vbs to help with this)
    • Remove boundaries form SMS2k3
    • Uninstall SMS 2k3 client using SMS 2k3
    • Using CM12 push, install CM12 client

    http://www.enhansoft.com/

    • Marked as answer by Garth JonesMVP Monday, December 22, 2014 3:20 AM
    Wednesday, January 23, 2013 1:12 PM

All replies

  • Why don't you move to System Center 2012 Configuration Manager instead? Why start without date software?


    http://www.enhansoft.com/

    Tuesday, January 22, 2013 1:20 PM
  • I guess there isin't any direct path from 2003-2012.... So I wanted to have 2007 in place .

    There is not direct upgrade from CM07 to CM12 either so. I'm not sure what you hope to get to do this any way.  This seem like a lot of effort for little gain.

    http://www.enhansoft.com/

    Tuesday, January 22, 2013 6:43 PM
  • well, my plan is to go from SMS 2003 to CM07 1st and , I would be planning for CM12 at later stage. But my initial target is to get-rid of my old hardware in place and use a new one. So I came up with a strategy to use a new hardware and Install SMS 2003 and Copy the DB from the old server and do a restore. Now as this server is Officially SMS 2003 I can upgrade it to CM07. So back to my question , My Environment is a little small. I have a Central, Primary and a Secondary site and Central and Primary has SQL on both and If I copy the DB of Central to new hardware and do a restore , then will it be SMS 2003 ? and what do I do with the Primary and Secondary ?? I would like to have only 1 server when moving to CM07.
    Wednesday, January 23, 2013 10:32 AM
  • No you can’t copy the database to the new server like that. You must use the SMS 2k3 Backup task for each site.  This is where you will be cause yourself a ton of extra work. When you do the restore it MUST be restore to the exact same setup as when it was back up.  Here is a simplified plan of what you need to do.

    SMS2k3 - > SMS2k3

    • Build new server
    • All drives must look the same.
    • SQL must be the same, setup, you can change SQL version but keep in mind that
      • The collation must be the same
      • You must use be a supported version of SQL
    • Windows must be the same, but you can upgrade windows to a supported version (Windows 2003 only?? http://technet.microsoft.com/en-ca/library/cc181628.aspx)
    • Make sure everything is ok before move to next step

    SMS2k3 – CM07

    • Upgrade Server from SMS2k3 – CM07
    • Upgrade Clients
    • Make sure everything is ok before move to next step

    CM07 – CM12

    • Build new server
    • Install Windows 2012
    • Install SQL 2012
    • Install CM12
    • Migrate Packages
    • Remove boundaries form CM07
    • Upgrade Clients

    Without knowing too much about your environment, I would suggest that you create 1 CM12 primary site and maybe a secondary site.

    BTW this is the high level plan for going directly to CM12

    SMS2k3 – CM12

    • Build a new server
    • Install Windows 2012
    • Install SQL 2012
    • Install CM12
    • Migrate Packages – Export / Import (there are vbs to help with this)
    • Remove boundaries form SMS2k3
    • Uninstall SMS 2k3 client using SMS 2k3
    • Using CM12 push, install CM12 client

    http://www.enhansoft.com/

    • Marked as answer by Garth JonesMVP Monday, December 22, 2014 3:20 AM
    Wednesday, January 23, 2013 1:12 PM
  • Okay, I take plan the 1st plan, SMS2k3-SMS2k3-CM07..... what are the possibilities if I use a different drive configuration ? In my Old SMS2k3 I have 3 drives and now I would like to spread them into 6 . Ex: I have all SQL in one place in my Old and I would like to have different drives for each logs,backup,SQL install. 
    Wednesday, January 23, 2013 1:55 PM
  • In theory it must be exactly the same, however SQL is a bit of an exemption. You should be able to do that but honestly, my question would be why would you do it?  I assume this will be a RAID 5 /10 setup and you will create logical drives. What do you hope to gain with this, setup? How many PCs are we talking about?


    http://www.enhansoft.com/

    Wednesday, January 23, 2013 3:33 PM
  • As I told you, My primary goal is to get rid of the hardware that we are ON right now and have exactly the same features that we are using in SMS2k3 on a fresh hardware and I guess it would be RAID 5. Well I have about 1000 machines.
    Wednesday, January 23, 2013 3:41 PM
  • For 1000 PCs, I wouldn’t bother break up the db, log and backups. If it all on 1 RAID 5 setup, you will hurt the performance instead of help it by doing this. Heck, if I could I would make 2 drive only, C:\ &  D:\ from a performance stand point there will be no difference.


    http://www.enhansoft.com/

    Thursday, January 24, 2013 1:15 PM
  • Okay, So I would stick with the same partitions that I am having in the Old SMS. 

    There is another thing I would like to ask... Well I have a Central-Primary and a Secondary in my Old SMS2k3,I mostly do my Operations through Primary, Now If I want to construct the SMS2k3 on a new hardware, Can I consolidate them into a single Primary ??

    Like Building SMS2k3 on new hardware, with same drives as old.

    Copying the source files, packages onto new hardware , create a new DB, name it as old, do a site restore from backup and shutdown the Old. Upgrade to CM07.

    But here in my new hardware I need only one Primary, The client cannot afford any more hardware now. And for 1000 clients I don't think I need more than that.

    Jimmy

    Friday, January 25, 2013 10:05 AM
  • It sound like the Central site is not used, if so then yes you could get rid of it. Why question would be why was it there in the first place?

    What are you going to do about your secondary server? You can get rid of it, but again the question is: Why was it there in the first place?

    Ultimately you can do anything that you want but without proper planning thing maybe worse than as there are. This is part of the reason why I STONGLY suggest that you move directly to CM12. You only have to plan once and you can leverage BranchCache to reduce the number of servers that you might need.


    http://www.enhansoft.com/

    Friday, January 25, 2013 1:11 PM
  • I am not sure why they had a Central in place not using it. That was done years ago and have no clue, Secondary is serving as a DP , its in a different geographical Location. 

    Can you tell me how do I achieve this ? a High level plan may be please ?

    For 2012, I am not sure , Client asked me for 2007 I guess they don't have resources trained on or worked on 2012 as of now. I tried my best to get them on 2012. But that's planned for 2014 as of now. So for now I am with 2007 and if this goes well, I will get to do the 2012 soon again.

    Friday, January 25, 2013 1:30 PM