How to export data? - MS SQL Server Q&A

Brothersoft.com Windows|Mac|Mobile|Games

Find answers Ask a question

Tags:

development ms sql server sql server download free microsoft sql server tutorial microsoft sql server management studio express

development× ms sql server× sql server download free× microsoft sql server tutorial× microsoft sql server management studio express×

Done

How to export data? 01/12/2012 14:11 by Scott Lackey: I've got data in one tabe on a dev server, and I wish to export that data verbatim into the corresponding table on the production server. Is there a quick and dirty way to do this? One field is an identity field, by the way. using Microsoft SQL Server Mamagement Studio Express.; First answer posted by DanielSimon at 01/13/2012 04:57

4 Answers

DanielSimon
To export data from SQL Server:
1. Open the SQL Server Management console. This software shortcut is located in the "SQL Server" group in your Windows "Start" menu.
2. Login to the console using the sa (system administrator) account and password. Exporting data from tables takes elevated access, so using sa is preferred.
3. Right-click a table in the database and select "Export data..." from the menu list. This starts a wizard that guides you through the export process. Click the "Next" button at the opening screen.
4. Enter the server name in the source window's dropdown box labeled "Server." Click the arrow in the dropdown box labeled "Database" to view a list of databases on the server. Select the database in which the table is located. Click the "Next" button.
5. Select "Flat File" from the data source dropdown box in the "Destination" window. Enter a name for the new CSV file and press the "Next" button.
6. Check the box for the table data you want to export. You can also choose multiple tables to export. Click the "Next" button. At the summary screen, click the "Finish" button. This triggers SQL Server to export the data to a text file. Depending on the size of the tables, it can take several minutes to export.
Was this answer helpful? 1 0　·　01/13/2012 04:57

JGebauer
Follow these to copy a SQL Table From one database to the other:
1. Click the Windows "Start" button and select "All Programs." Click "SQL Server" in the program groups and then click "SQL Server Management Studio." This opens the main administration console.
2. Right-click the database name on the left side of your management console and select "Tasks," then choose "Export data." This opens the SQL Server import and export wizard.
3. Select the name of the SQL Server from which you want to export records. If you are running the management console from the export server, the default value is the current name of the database, so you do not need to make changes. Click "Next."
4. Enter the database name for the destination server. Click "Next." Enter "Tables" from the list of objects you want to export. Click "Next."
5. Check the boxes next to each table you want to export to the destination SQL Server. You can select one or several tables. Click the "All" button to quickly check all tables on the SQL Server. Click "Next."
6. Click the "Save" button if you want to save the settings as a package. This allows you to run this same export process from the Management Studio console without setting up the configurations again. Click "Run" to complete the settings and transfer the tables to the destination SQL Server.
Was this answer helpful? 1 0　·　01/13/2012 05:11

NataliaPeterson
Microsoft SQL Server Mamagement Studio Express is no longer used after 2005.

Now we got SQL Server Management Studio that got all functions added in.
Was this answer helpful? 1 0　·　01/13/2012 05:14

SteveQueen
Navigate to this page from Microsoft SQL Server support center and learn how to run the SQL Server Import and Export Wizard:

http://msdn.microsoft.com/en-us/library/ms140052.aspx
Was this answer helpful? 1 0　·　01/13/2012 05:26

Related Questions: Q:How to Use MSDE Writer in 2005 MS SQL Server
A:Verify the MSDE Writer Presence Click the "Start" button and then click "Run." Type "cmd /k" in the text box provided and click the "OK" b...(more); Q:how do I embed widgets for Stumbleupon?
A:Navigate to stumbleupon.com/widgets and click the “Get Started” button. Click “User Favorites” to display favorites from your Stumble...(more); Q:how to create an array of sequential numbers in ruby?
A:Load the Ruby interpreter by clicking on the "Interactive Ruby" icon located under "Programs" in the Windows start menu or "Applications" in t...(more); Q:how to make lightning effects with GIMP?
A:Click "Filters" at the top of the screen. Choose "Render" from the drop-down menu. Select "Clouds" from the slide-out menu and choose "Differe...(more); Q:how can I make and publish a cookbook online?
A:Writing Recipes List ingredients in their order of use. Include accurate measurements and the state in which ingredients are to be used, such...(more)

1 people are following

Ask a question now

Write a title for your question

More Hot Questions: What do you think of Microsoft SQL Server?; What Are Some Advantages & Disadvantages of MS Excel & Access?; Filemaker 8 Tutorial; What Is FileMaker?; Advantages & Disadvantages of FileMaker & Access; Features of FileMaker; Uses for Ports in FileMaker; JDBC ResultSet Example; What Is a Router Table?; The Disadvantages of Database Denormalization

Microsoft SQL Server

Enable your organization to scale database operations with confidence: Latest version:2008 SP3; License:Shareware; OS:Windows 7/Vista/2003/XP/2008; Total downloads:186,757; Rank:2 in Databases; Download It

Share with friends

New features is coming

1. Providing high-quality answers to be a verified Q&A expert
2. Ask and answer questions to get Brothersoft credits

Popular Tags

office tools(28174) photo & image(21438) system utilities(18690) dvd & video(15856) mp3 & audio(5474) home & education(2660) windows(2577) apple "back to the mac" fall 2010 event(2227) facebook "download your information"(2185) social & communication(1873)

Added Successfully!

×

Are you sure to delete your answer?

×

Are you sure to choose it as the best answer?

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×