Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

How to copy a table structure and data to a different server? Expand / Collapse
Posted Monday, April 29, 2013 6:11 PM



Group: General Forum Members
Last Login: Today @ 9:38 AM
Points: 42,077, Visits: 39,464
The script that generates out as individual INSERT scripts is going to be comparatively and, maybe, horribly slow. With that thought in mind, I recommend doing the right click thing to generate the script for the table creation and the use of BCP in the "native" mode to export the data to a disk and then import it using either BCP or BULK INSERT on the other server.

If this is something that needs to be done on a regular basis, consider one form of replication or another.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1447822
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse