-1

This question already has an answer here:

How do I transfer a database from a physical server running SQL Server 2012 to another server running SQL Server 2008 Express? The database was created by sa under SQL Server 2012.

Thank you.

marked as duplicate by Kin Shah, Aaron Bertrand Aug 4 '14 at 14:23

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.

  • Is there anything stopping you from upgrading SQL Server 2008 Express to SQL Server 2014 Express, or installing the new version alongside 2008? It's free after all... – Mark Sinkinson Aug 4 '14 at 14:01
1

How do I transfer a database from a physical server running SQL Server 2012 to another server running SQLEXPRESS 2008

Direct transfer of database using backup restore or using attach dettach is not possible because you cannot move database from higher version(SS 2012) to lower version(SS2008). Its not allowed by Microsoft.

What you can do is script out the objects manually run the script in destination database and then use import export wizard to move data. This link would help

Moreover SQL Server 2008 express database has limitation of 4 G database. So when you move data using Imp exp wizard make sure you do not exceed the limit.

PS: If you would have searched the net you could have found lot of similar threads on how to achieve this.

  • There are also numerous other compatibility issues to be addressed, unless the DB was created on 2012 at an appropriate compatibility level. – Pieter Geerkens Aug 4 '14 at 13:59
  • 1
    As an aside, if you are trying to go to express 2008R2, the database size limit is 10GB. – SQLRNNR Aug 4 '14 at 14:00
  • @Pieter and even at compatibility level = 100, this doesn't stop you from using things in 2012 that will break on 2008 (code that will stop working, or objects that just won't transfer). – Aaron Bertrand Aug 4 '14 at 14:24

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