Copying data

Accepted 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/

0

Sam Hobbs15y ago

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.

0

dc15y ago

Can you tell me about linked servers?

0

Jaish Mathews15y ago

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.

0