Development of SQL Server 2008 & 2008 R2

Discussion in 'Databases' started by ruggernut, Oct 10, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. ruggernut

    ruggernut

    I currently have a SQL Server 2008 as part of my production system. If I develop with 2008 R2 (specifically express 2008 R2), can I migrate any changes made in the 2008 R2 development database to my 2008 production database? Any changes might be limited to database schema and changes to SP/Views. I am in the stages of planning a new ground up version of my production database. Will I need to upgrade my production database to 2008 R2 for this?
     
    ruggernut, Oct 10, 2010
    #1
  2. wisemx

    wisemx

    wisemx, Oct 10, 2010
    #2
  3. dmitri

    dmitri DiscountASP.NET Staff

    You should be aware that SQL Server 2008 R2 backups cannot be restored to SQL Server 2008 or any previous version. It can be restored to R2 version only. It is a good idea to upgrade your current version of SQL Server. Please see this community post for the general steps.
     
    dmitri, Oct 11, 2010
    #3
  4. ruggernut

    ruggernut

    The steps listed are fairly clear - are there any for a 2008 to 2008 R2 upgrade?
     
    ruggernut, Oct 11, 2010
    #4
  5. dmitri

    dmitri DiscountASP.NET Staff

    The steps to upgrade to R2 version are the same. Those are the general steps to upgrade any version of SQL Server.
     
    dmitri, Oct 11, 2010
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page