I'm looking to copy and transfer all the data from 3 tables on our backup server to our live server in 3 new tables. Thru tasks > Import Data, I got close. Stopped when I "couldn't" create new tables for these copied tables. It only allowed me to append into an existing table. Is there a better way?
I just thought of a way which is by first doing a select * into "New Table" with existing data in live server. Then do the task>import data into those new tables and edit mappings to delete rows in destination table.
Is there a better way?