Move database from SQL Server 2012 to 2008
Results 1 to 2 of 2

Thread: Move database from SQL Server 2012 to 2008

Hybrid View

  1. #1
    Join Date
    Jul 2016
    Location
    USA
    Posts
    1

    Move database from SQL Server 2012 to 2008

    I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried).

    I cannot find any options in 2012 to create a 2008 compatible backup. Am I missing something?

    Is there an easy way to export the schema and data to a version-agnostic format which I can then import into 2008?

    The database does not use any 2012 specific features. It contains tables, data and stored procedures.

    Anyone suggest how to move database SQL Server 2012 to 2008.

    Thanks,

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,898
    Did you try changing compatibility level of database to SQL 2008, then taking backup of it?.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •