How to export database with data in MSSQL?

sql-server database sql-server-2008 sql-server-2012 export
Jamie picture Jamie · Aug 21, 2013 · Viewed 46.5k times · Source

How can I export my 2012 database with data to a .sql file so I can import it to a 2008 server? I've never been able to export the data only the structure.

Answer

Vinu picture Vinu · Aug 23, 2013

You can right click on the database in management studio. then go to,

Tasks --> Generate scripts --> Advanced

There you can enable "Type of data to script" as Schema and data, then generate the script. So that your script file will be populated with your data in table.

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
how to schedule a job for sql query to run daily?

I need to know how to make a SQL query run daily using a SQL Server Agent job, with minimum required configuration settings.

Read More
Querying data by joining two tables in two database on different servers

There are two tables in two different databases on different servers, I need to join them so as to make few queries. What options do I have? What should I do?

Read More