SQL Server database management Tutorials // IT Management Solutions

SQL Server database management Tutorials

Simple way to export data from SQL Server &nbsp

(Export Wizard)

Overview
SQL Server Management Studio (SSMS) provides the Export Wizard task which you can use to copy data from one data source to another. You can choose from a variety of source and destination data source types, select tables to copy or specify your own query to extract data, and save your work as an SSIS package. In this section we will go through the Export Wizard and export data from a SQL Server database to an Excel spreadsheet.

Explanation
To begin launch SSMS by clicking SQL Server Management Studio from the Microsoft SQL Server program group. Upon launching SSMS you will be prompted for a connection; connect to the Database Engine. For demonstration purposes we will use the AdventureWorksDW database. You can download the AdventureWorksDW sample database from the CodePlex site.

Locate the AdventureWorksDW database in the SSMS Object Explorer; if the Object Explorer isn't visible click the View menu then select Object Explorer:

Right click on the AdventureWorksDW database in the Object Explorer, select Tasks, then Export Data from the context menu to launch the Export Wizard. Click Next to advance past the Welcome dialog (if shown). In the following sections we will walk through the wizard step-by-step.

Choose a Data Source

The Choose a Data Source dialog allows you to specify the source of your data. Since we are running the Export wizard, the dialog will be displayed with the values already filled in as shown below (based on the database you right clicked to start the Export wizard):

Click Next to proceed to the Choose a Destination dialog.

Choose a Destination

You might also like

SQL 2K5 answer

by baseLogiK

How you do this will depend on if you are using SQL Management Suite or raw T-SQL through another app, like OSQL. For the management suite, you can connect to the server, expand the databases, expand your database, expand tables, and then right click and choose design on the table in question. From there, just hold control and click the two columns followed by a right click (on either one) and choose set primary key.
For T-SQL, run the following against your DB substituting of course your table name and your columns.
ALTER TABLE MyTable ADD CONSTRAINT PK_MyTable_SomeDescription PRIMARY KEY CLUSTERED
(
MyFirstColumnName,
MySecondColumnName,

Sams Publishing Sams Teach Yourself SQL in 10 Minutes (4th Edition)
Book (Sams Publishing)
  • Used Book in Good Condition

Shielding names of police, prosecutors in online tax records divides lawmakers  — WRAL.com
Paul Stam, R-Wake, said counties would spend millions of dollars managing databases where some names were out in the open and others weren't. "This idea that you can have two different sets of records electronically – one at the courthouse and the ..

McGraw-Hill Osborne Media Microsoft SQL Server 2012 A Beginners Guide 5/E
Book (McGraw-Hill Osborne Media)
Wrox Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)
eBooks (Wrox)
McGraw-Hill Osborne Media Microsoft SQL Server 2008 Reporting Services
Book (McGraw-Hill Osborne Media)
Wrox Professional Microsoft SQL Server 2012 Integration Services
Book (Wrox)
  • Used Book in Good Condition

Related Posts



Copyright © . All Rights Reserved