Where do Exported Tables go in SQL Server 2008?

Posted on 2012-08-22
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
    LVL 12

    Expert Comment

    by:Habib Pourfard
    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

    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.


    LVL 9

    Expert Comment

    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
    LVL 9

    Expert Comment

    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

    Right click on your database > Tasks > Generate scripts...

    1. select "Select specific database objects" and select the desired tables.
    Step 1 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

    Thank you, you are a genius!

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now