This is an easy job if you have sql server manager or enterprise manager or another tool. There are approx 4 tables that I need to move from one server to the other. I want for you to 1. Back up the original tables by renaming them 2. Create new tables with the data from the other server.