I may be missing something obvious here, but is there a way to copy a table and all its data (possibly minus the constraints) to another database in one go?
I have so far been getting the create script, running it on the other db (on another server) then importing the data. I just wondered if there was a quicker way?
I have so far been getting the create script, running it on the other db (on another server) then importing the data. I just wondered if there was a quicker way?