How to export database including structure and data from sqlserver 2008 to sqlserver 2005
In a case that I need export data from SQL 2008 to SQL 2005, not only the database itself but also the data inside.
I find out the solution as:
1) Right click the database in sql 2008 which you want to do with
2) Choose Task and Generate script
3) Make sure select "script all objects in the database"
4) In the Script Option, choose the item Script for SQL server version to SQL2005
and Script data to be true! Those two are the key steps!
5) Here you go to check the generated script. You should find out insert statement for inserting the data
TO be honest, this feature is not obvious or stated clearly in SQL 2008.
I find out the solution as:
1) Right click the database in sql 2008 which you want to do with
2) Choose Task and Generate script
3) Make sure select "script all objects in the database"
4) In the Script Option, choose the item Script for SQL server version to SQL2005
and Script data to be true! Those two are the key steps!
5) Here you go to check the generated script. You should find out insert statement for inserting the data
TO be honest, this feature is not obvious or stated clearly in SQL 2008.
Comments