I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. (we need to copy an old ...

This article outlines how to use the copy activity in a pipeline to copy data from and to SQL server. Connection: Select a SQL server connection from the connection list. If the connection doesn't ...