Solved

Sql to make a dump file of a table's DDL and data in SQL Server?

Posted on 2009-07-07
3
216 Views
Last Modified: 2012-05-07

Hi,

Can anyone tell me the SQL command to make a dump file of a table's DDL and data in SQL Server?  Thanks!!
0
Comment
Question by:superoneio
[X]
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
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 125 total points
ID: 24794644
Probably the easiest is to use the Microsoft SQL Server Database Publishing Wizard 1.1.

You can also do a backup and restore. It all depends what you want to do.


Microsoft SQL Server Database Publishing Wizard 1.1
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
0
 

Author Closing Comment

by:superoneio
ID: 31600591
Thanks you're a genius!!!
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 24794927
>> Thanks you're a genius!!!

So they tell me. ;-)

Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore 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.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 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