Copying Tables in SQL Server

Here is a post that talks about the details of transferring tables from one SQL Server to another.

The moving of tables from one SQL Server to another has been a constant issue for me. I sometimes need to move the changes to a database where I do not have the ability to directly connect. In that case, I end up using a third party tool such as SQL Compare and SQL Data Compare from Red Gate that allows me to generate scripts that I can then pass off to the administrator of the database I need to update.

In order to do this, I often need to get a backup from the database I need to move changes to, and then restore that database locally so that I can create the script that will make both databases the same, both in structure and in some cases, in data.

Posted by Douglas Reilly at 02:22 PM  Permalink