I have several tables in a database that I want to restore from another database on another server.
I have used the Import data SQL tool to bring a copy of the tables onto the destination server. My plan was to truncate the tables and then use a SELECT * FROM SOURCE INTO DESTINATION. This failed because the tables contain foreign keys and other constraints.
Is there a quick way to refresh this data or do I need to drop all of the constraints and then re-apply once the data has been copied?