question

sqldev16 avatar image
sqldev16 asked

data load (transfer)

I have several hundred tables. I have to transfer data from one server to another. Tables on destination server are slightly different (have extra fields). Source is sql 2005, destination is sql 2012. They are resides on different servers. What is the best way do implement this?
data-transfer
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
David Wimbush avatar image
David Wimbush answered
It sounds like a job for a schema and data comparison tool to me. For a few tables I would script it by hand but not several hundred tables. I would see what the usual SQL tools vendors have to offer and check those tools out. I suggest looking at (in no particular order): Idera, Red Gate, Dell, SQL Sentry. There might be something in Visual Studio Data Tools if you have access to that.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.