MS SQL Server 2008R2 – Create sql dump file to copy database schema and all object

One of my website vendor ask me to send a dump file from SQL Server. And I don’t know how to created that L, because I’m newbie in SQL server.

After googling an hour I found this article, and for reminds me how to created the dump file I created this article.

Step 1 : Choose the Database

Step 2 : choose the file path and choose the types of data

And then choose next

And now your sql dump file are ready to use. I hope this article will help people like me who doesn’t know too much about MS SQL. 😀


  1. Balmipour · October 29, 2013

    Really nice, but… how do I do the same using command line ?
    Most of the results I find are about creating a stupid .bak… I Want real sql dumps !

    Any tip about that ?

  2. alex · May 8, 2014

    Very happy to have found this article. God bless you!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.