You must Sign In to post a response.
  • Category: SQL Server

    DB restoration from sql server 2012 to 2005

    how to restore database from SQL server 2012 to 2005 . i am unable to do is there any way

    please help me


  • #765425
    No, is not possible to downgrade a database. It is not allowed.
    What you have you to do is
    1. Upgrade your current SQL from 2005 to 2012
    2. restore the backup you have on a SQL Server 2012 instance, export all the data and import it on a SQL Server 2005 database.
    OR You can create a query to generate sql table structure with data and its constraints
    OR You can use functionality called Export Data-Tier Application which generates .bacpac file consisting database schema and data. On destination server, you can use Import Data-Tier Application option which creates and populates new database from pre-created .bacpac file
    Right click on database -> Task->Generate Scripts... in Advanced in "Types of data for script" select "Shema and data" And try run this script in your lower version

    Hope it helps

    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #765436
    Refer the below link

  • #765491

    Below options can help us to downgrade the database from a higher version of SQL Server to a lower version SQL Server. These options include:

    Generate Scripts wizard of SQL Server Management Studio
    SQL Server Integration Services
    Custom scripting and BCP
    In this tip we will use the Generate Scripts wizard of SQL Server Management Studio. Here are the basic steps we need to follow:

    Script the database schema in higher version of SQL Server by using the Generate Scripts wizard of SQL Server Management Studio interface.
    Connect to the lower version of SQL Server, and then run the SQL scripts that were generated in the previous step, to create database schema and copy data.

Sign In to post your comments