locked
CRM 1.2 and SQL Server 2005 RRS feed

  • Question

  • My CRM databases are located on a Sql Server 2000 instance, as well as Sharepoint databases and other databases.

    I'm now in need to upgrade the database server to Sql Server 2005 and I'm trying to understand if CRM 1.2 is compatible with it.

    As I do not have any CRM 1.2 disconnected client I'm not using replication, so I see why it couldn't work ...

     

    Thanks in advance.

    Friday, January 18, 2008 4:50 PM

Answers

  • While CRM 1.2 is not support or designed for SQL 2005, you might be able to get away with an upgrade of your SQL Server if you make sure to remove all traces of replication first. Also, you might consider doing a re-deployment using the Redeployment Tool on the CRM 1.2 Server CD. I would back everything up and have a good understanding of how to recover if the redeployment doesn't work.

     

    Also, to put in a plug for the later versions of CRM: You're missing a good opportunity to upgrade! While you can't go from 1.2 directly to 4.0, you will get a lot more functionality and stability even if you upgrade only to 3.0. Plus, it would be interesting to hear how a two-version upgrade goes if someone's willing to be the guinea pig and upgrade from 1.2 to 3.0 and then immediately to 4.0. ;-)

     

    Matt Wittemann

    CRM MVP

    http://icu-mscrm.blogspot.com

    Friday, January 18, 2008 7:11 PM
    Moderator
  • Dear,

     

    I do recommend to add that customization manually if only few feilds, as upgradation might be cause some problem.

     

    I would suggest export data into excel and then use Data migration to import using csv.

     

    here is best link how you can import multiple  http://blogs.msdn.com/crm/archive/2008/01/04/microsoft-dynamics-crm-4-0-data-migration-manager-with-john-o-donnell.aspx

     

    Best Regards,

    Imran

     

    http://microsoftcrm3.blogspot.com

     

    Tuesday, January 22, 2008 8:57 AM
    Moderator
  • As Imran pointed out you can export your CRM 1.2 data to CSV files and use the Data Migration Manager for 4.0 to import the data. The problem you will face is maintaining the relationships between records like accounts and contacts, associated activities, etc. Upgrading a "plain vanilla" 1.2 instance to 3.0 shouldn't be too painful, and there's lots of info on the web about how to do it since most folks have already gone that route. Good luck and post back here if you run into any difficulties.

    Tuesday, January 22, 2008 2:23 PM
    Moderator

All replies

  • While CRM 1.2 is not support or designed for SQL 2005, you might be able to get away with an upgrade of your SQL Server if you make sure to remove all traces of replication first. Also, you might consider doing a re-deployment using the Redeployment Tool on the CRM 1.2 Server CD. I would back everything up and have a good understanding of how to recover if the redeployment doesn't work.

     

    Also, to put in a plug for the later versions of CRM: You're missing a good opportunity to upgrade! While you can't go from 1.2 directly to 4.0, you will get a lot more functionality and stability even if you upgrade only to 3.0. Plus, it would be interesting to hear how a two-version upgrade goes if someone's willing to be the guinea pig and upgrade from 1.2 to 3.0 and then immediately to 4.0. ;-)

     

    Matt Wittemann

    CRM MVP

    http://icu-mscrm.blogspot.com

    Friday, January 18, 2008 7:11 PM
    Moderator
  • Hi David,

     

    Check the redeployment tool. and for upgrading your database.

     

    this is http://www.sonomapartners.com/docs/MicrosoftCRM3UnsupportedUpgrade.pdf  bes practice guide ..

     

    After upgrading to ms crm 3.0, then you can upgrade to CRM 4.0.

     

    Regards,

    Imran

     

    http://microsoftcrm3.blogspot.com

     

     

    Monday, January 21, 2008 6:01 AM
    Moderator
  • Thanks for your advice.

    I'm not so confident about the upgrade process from 1.2 to 3.0 but if I have to, I will upgrade up to the latest version 4.0, after 3.0.

     

    Customization in my CRM server are just few fields added to some entities, no workflows, no replication and disconnected clients, no 3rd party integration ... but from my past experiences I know version upgrade processes are not the best designed features in Microsoft products.

     

    Is there a way to export all the data from 1.2 and import it back into a new 4.0 server? 

     

    Thanks again

     

     

    Tuesday, January 22, 2008 8:40 AM
  • Dear,

     

    I do recommend to add that customization manually if only few feilds, as upgradation might be cause some problem.

     

    I would suggest export data into excel and then use Data migration to import using csv.

     

    here is best link how you can import multiple  http://blogs.msdn.com/crm/archive/2008/01/04/microsoft-dynamics-crm-4-0-data-migration-manager-with-john-o-donnell.aspx

     

    Best Regards,

    Imran

     

    http://microsoftcrm3.blogspot.com

     

    Tuesday, January 22, 2008 8:57 AM
    Moderator
  • As Imran pointed out you can export your CRM 1.2 data to CSV files and use the Data Migration Manager for 4.0 to import the data. The problem you will face is maintaining the relationships between records like accounts and contacts, associated activities, etc. Upgrading a "plain vanilla" 1.2 instance to 3.0 shouldn't be too painful, and there's lots of info on the web about how to do it since most folks have already gone that route. Good luck and post back here if you run into any difficulties.

    Tuesday, January 22, 2008 2:23 PM
    Moderator