0

This question already has an answer here:

Is it possible to load a backup of SQL server 2014db into SQL server 2012?

Trying to import/restore is throwing backward compatibility issues.

Thanks

marked as duplicate by Kin Shah sql-server Apr 15 '15 at 10:41

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

migrated from stackoverflow.com Apr 15 '15 at 8:30

This question came from our site for professional and enthusiast programmers.

4

You CANNOT do this - you cannot attach/detach or backup/restore a database from a newer version of SQL Server (2014) down to an older version (2012) - the internal file structures are just too different to support backwards compatibility.

You can either get around this problem by

  • using the same version of SQL Server on all your machines - then you can easily backup/restore databases between instances

  • otherwise you can create the database scripts for both structure (tables, view, stored procedures etc.) and for contents (the actual data contained in the tables) either in SQL Server Management Studio (Tasks > Generate Scripts) or using a third-party tool

  • or you can use a third-party tool like Red-Gate's SQL Compare and SQL Data Compare to do "diffing" between your source and target, generate update scripts from those differences, and then execute those scripts on the target platform; this works across different SQL Server versions.

  • Can you do it if the database would be in 110 compatibility mode? – BuahahaXD Apr 15 '15 at 9:47
  • 2
    @BuahahaXD: No, even with a "back dated" compatibility level setting the database structures will be those of SQL2014. The compatibility modes only affect certain behaviour, not the underlying structure. – David Spillett Apr 15 '15 at 10:13
  • DBAreactions to this question – Yaroslav Apr 15 '15 at 10:25

Not the answer you're looking for? Browse other questions tagged or ask your own question.