Tag: sql server express copy database tables to another database

SQL Server tutorial: Copy database tables to another database

Posted on by

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. Continue reading