Solved

Exporting MSSQL database to .SQL file including Data

Posted on 2008-09-30
3
299 Views
Last Modified: 2012-05-05
I have a MSSQL database which i am managing with MS SQL Server Management Studio 2005. Can someone explain me how I can export a database into a .SQL file including the INSERT statements for the data?

I've managed to do it before but I forgot how I did it,

Thanks.
0
Comment
Question by:inghfs
3 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 22613608
I've seen a utility for MySQL that does this ...

In MS SQL Server, scripting the schema out is simple -- from your question I think you've already figured that out.

To get the data, I recommend BPC.

Of course ... if transferring the entire DB is what you want to do, a backup file is actually preferable.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now