Import / Export database with SQL Server Server Management Studio

sql-server import export ssms
marcgg picture marcgg · Jul 14, 2009 · Viewed 360.1k times · Source

I thought this would be trivial, but it isn't... I'm sure there is a simple way to do it but I can't manage to find it. Shame on me.

I want to import/export the database itself, the tables, the constraints (foreign keys and so on). I'd rather not get the data with it, but I can get rid of it after if there's no other way.

So... how do you export a database using MS SQL Server Management Studio ? How do you import it?

The only solution I found was right click on the tables and "script to Create", but I have something like 100 tables, so I'd rather avoid this.

Thanks!

Answer

Brandon picture Brandon · Jul 14, 2009

Right click the database itself, Tasks -> Generate Scripts...

Then follow the wizard.

For SSMS2008+, if you want to also export the data, on the "Set Scripting Options" step, select the "Advanced" button and change "Types of data to script" from "Schema Only" to "Data Only" or "Schema and Data".

Related questions

Best (easiest) way to make a SQL Server dump and import that dump in another SQL Server

I would like to achieve a database export (dump) in SQL Server from one server and import that dump in another SQL Server and not necessarily in the same schema name. For example if I have a database prepared with …

Read More
Import Excel spreadsheet columns into SQL Server database

I have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard didn't offer that option. Do any easy code options exist?

Read More
How to import an Excel file into SQL Server?

I have data in an Excel file - actually xlsx format since it is now 2020. My requirement is to get this data into SQL Server as follows: ad hoc, the use-case being feeding tables with test data, or infrequent data …

Read More