Using SQL Server Management Studio To duplicate a table. You also need to create the destination database and the destination table in server-B as described earlier. SQL Cloning Tables. In Object Explorer, right-click Tables and click New Table. SQL Server Functions. Or, you can copy data from any supported source data store to a SQL Server database. The following SQL statement uses the IN clause to copy the table into a new table in another database: SELECT * INTO CustomersBackup2017 IN 'Backup.mdb' You can copy data from a SQL Server database to any supported sink data store. For a list of data stores that are supported as sources or sinks by the copy activity, see the Supported data stores table. Make sure you are connected to the database in which you want to create the table and that the database is selected in Object Explorer. In this tutorial you will learn how to create a duplicate copy of an existing table. The SELECT INTO statement copies data from one table into a new table. There may be a situation when you just want to create an exact copy or clone of an existing table to test or perform something without affecting the original table. The SQL SELECT INTO Statement. This method assumes there is communication between an app-server (that has Visual Studio with SSDT tools installed) to server-A and the same app-server to server-B. Using SSIS to Copy a SQL Server Table to Another Server. Users of SQL Server Database work with various database components including Table, Views, Stored Procedures, etc. In Object Explorer right-click the table you want to copy and click Design. In many cases, user may need to copy the SQL Server table schema and data from one database to another database in the same instance or different SQL instance. Cloning or Copying a Table.