Post reply

upgrade sql 2008 10.00.1600.22 to SQL Server 2008 R2 10.50.1600.1

  • December 22, 2011 at 2:37 am

    #265340

    I have installed SQL Server 2008 -10.00.5500 on Computer-A

    and other on computer -B

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 6.0 <X86> (Build 6001: Service Pack 1)

    I am trying to restore the database of R2 (RTM) - 10.50.1600.1 in SQL Server 2008 -10.00.5500 but it's showing compatibility (higher version) error.

    will i need to uninstall SQL Server 2008 -10.00.5500 first then install SQL Server 2008 R2 (RTM) - 10.50.1600.1 ?

    How Can old version be upgrade????

    Thanks & Regards,
    Pallavi

  • December 22, 2011 at 2:54 am

    #1424645

    Its not possible to restore database from higher to lower version .. there is now way for Degrdation . you can script out the database objects without data ,create database using the script and then export the data using import export tool.

    java[/url]

  • December 22, 2011 at 3:12 am

    #1424656

    How Can old version be upgrade????

    How to: Upgrade to SQL Server 2008 R2 (Setup)

    http://msdn.microsoft.com/en-us/library/ms144267.aspx

  • December 22, 2011 at 3:16 am

    #1424660

    But M trying to export and import it's not taking data.... where could i find the setting for data exporting????

    Thanks & Regards,
    Pallavi

  • December 22, 2011 at 3:20 am

    #1424663

    pallavi.unde (12/22/2011)

    But M trying to export and import it's not taking data.... where could i find the setting for data exporting????

    Did you select the table you wanted to export? Does it have any data? Are you pulling right table (verify schema name)?

  • December 22, 2011 at 3:28 am

    #1424673

    is there need to have or to exist a table in database where we are transfering data??

    Thanks & Regards,
    Pallavi

  • December 22, 2011 at 3:39 am

    #1424681

    Depends how you're doing the transfer.

    Easiest way, if it's a small number of tables is the Import/Export wizard. That will create the table for you, but you'll still have to add all the constraints, indexes, any triggers, defaults, etc.

    Probably better to script the structure first (including any procedures, views, functions, etc that you need, and then transfer the data across.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply