Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Exporting MSSQL database to .SQL file including Data

Posted on 2008-09-30
3
304 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need to start a web service from Visual Studio 2015 Pro 2 35
Switching Visual Studio 2015 to normal debug display 3 39
asp.net mvc5 6 23
hbo knew my windows software 4 62
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

829 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