To export the table structure and data from one SQL Server database to another existing or new database, use the Export Data… function in SQL Server Management Studio. This procedure will not copy any of the other database objects such as constraints, stored procedures, or users.


  1. In the Object Explorer, right click the name of the database. Select Tasks >Export Data…


  2. The SQL Server Import and Export Wizard will open. Click Next.

    2010-08-18_18.08.58.jpg


  3. Select a Data source type and server name. Enter the DBA’s login information, then select the source Database from the dropdown menu. Click Next.

    2010-08-18_18.10.07.jpg


  4. You can either write your own query or use the wizard to select which tables to copy. For this example, we’ll use the wizard. Select Copy data from one or more tables or views.


  5. Select specific tables to copy, or leave all selected to copy all tables.


  6. Select the Destination database. Click New… to create a database from scratch to export the data to.


  7. Check Run immediately, and click Finish to start the process.