Copying data

Question

I would like to know how to copy data from the user acceptance test database server to my unit test database server. Both tables have the same format. I just need to obtain data to test with. The only way I can see to accomplish this task is to use the import wizard on the sql server 2008 r2 database.

Jaish Mathews · Answer

see this thread. Mainly many steps to link to one of the existing sql sever http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/0782364d-dcb0-4c45-8343-5bfc4406ead4/

Sam Hobbs · Answer

Also if you want to have a copy of the data that is nearly always the same you can set up your project so that the data is copied by the project each time the project is built. To be practical I think the better technique would be to copy the production data elsewhere then the project can be set up to do the copy from there.

dc · Answer

Can you tell me about linked servers?

Jaish Mathews · Answer

Hi Can you check with setting up linked servers for sql server? I done like long ago with a master server and couple of linked servers attached to it.