Where do Exported Tables go in SQL Server 2008?

Posted on 2012-08-22
Medium Priority
Last Modified: 2012-08-27
I'm on SQL server 2008.  I want to export a few tables of data to give to another sql server user.  I used the export wizard.  It completed successfully, but it never aske me to name the destination file and did ask my to chose a location. How do I find the export?


Question by:cipriano555
  • 2
  • 2
  • 2
LVL 12

Expert Comment

by:Habib Pourfard
ID: 38321192
When you use the export wizard, it first asks you to choose source server name. after that it asks you for destination server name, which you can select another sql server.

Author Comment

ID: 38321248
I guess I'm approaching this wrong.  I want to give someone, as in email, a  file.  If this just copies to another database (not doing a true export) then what do I do?  I know I can do a full back up, but I only want to give a few of the tables, not the whole system.



Expert Comment

by:Vijaya Reddy Pinnapa Reddy
ID: 38321270
1) right click on database select task-->Export
2)You will ask you to choose Data Source -- give the database which contian the tables those to be exported.
3)Next screen will ask you to choose Destination like SQ Server,Excel,Access, etc,
4)then select the tables to be exported
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.


Expert Comment

by:Vijaya Reddy Pinnapa Reddy
ID: 38321293
For that purpose export the data to excel/file destination/ms access.
Then ask the user to import that as discussed above. Instead of export select import.
LVL 12

Accepted Solution

Habib Pourfard earned 2000 total points
ID: 38321311
Right click on your database > Tasks > Generate scripts...

1. select "Select specific database objects" and select the desired tables.
Step 1
2.at next step, click advanced button.
Step 2
3. select "schema and data" from "types of data to script"
Step 3
it will generate a file containing database schema and data. you can email it and run it on another sql server.

Author Closing Comment

ID: 38336698
Thank you, you are a genius!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

840 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