Get .sql file from SQL Server 2012 database

If you just want to generate a .sql script you can do this by right-clicking the database in Object Explorer and choosing Tasks > Generate Scripts:

enter image description here

Then you can select database and all objects, or you can select just the table you want:

enter image description here

Then select a location, and be sure to go into Advanced before continuing:

enter image description here

Under advanced, at the very least, change types of data to script to “Schema and Data” (if the reason you are doing this rather than a proper backup is because you need to import the data into a database earlier than SQL Server 2012, you should probably change the target server version option to whatever version you’re targeting):

enter image description here

If you don’t have that option in Management Studio, you are probably still running the RTM version of the client tools. Full functionality has finally been made free as of SP1. Download the most recent version – SP2 – here:

http://www.microsoft.com/en-us/download/details.aspx?id=43351

(You want one of the SQLManagementStudio files.)

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)