Using SSIS to Copy a SQL Server Table to Another Server. 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. The SQL SELECT INTO Statement. 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. SQL Cloning Tables. The SELECT INTO statement copies data from one table into a new table. For a list of data stores that are supported as sources or sinks by the copy activity, see the Supported data stores table. 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' In this tutorial you will learn how to create a duplicate copy of an existing table. 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. SQL Server Functions. Cloning or Copying a Table. Or, you can copy data from any supported source data store to a SQL Server database. 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. In Object Explorer, right-click Tables and click New Table. You also need to create the destination database and the destination table in server-B as described earlier. 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. Using SQL Server Management Studio To duplicate a table. You can copy data from a SQL Server database to any supported sink data store.