<div>
Hi carjar1217,<br />
<br />
<a href="http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/" rel="ugc">http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/</a>
</div>


Hi carjar1217,

http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/ [http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/]

<div>
Right click the database, go to &quot;Tasks&quot; and try either the Import/Export tools or even better yet the &quot;Database Copy&quot; task (although this requires SSIS).
</div>


Right click the database, go to "Tasks" and try either the Import/Export tools or even better yet the "Database Copy" task (although this requires SSIS).

<div>
<div class="content wysiwyg-content">
Hello,<br />
I need to move a database that is currently on sql 2012 to 2008r2. Has anyone done this? If so, what steps did you follow? Did you just script it out?<br />
Thank you in advance!
</div>
</div>


Hello,
I need to move a database that is currently on sql 2012 to 2008r2. Has anyone done this? If so, what steps did you follow? Did you just script it out?
Thank you in advance!

move db from sql 2012 to 2008r2

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.