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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.