Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I use the Import Export Wizard on my workstation to move data from ServerA to ServerB does the data flow over the network directly from ServerA to ServerB? Or does it go from ServerA to my client, then to ServerB?

share|improve this question
    
ServerA to ServerB. You connect to ServerA using SSMS not your local client PC. –  DenisT Feb 21 at 19:45
    
The clarification I meant was that SSMS was running on my local PC, not ServerA. I just wanted to make sure my local client was not in the middle of the data transfer. –  Andy Feb 21 at 20:32
    
Your local PC just a client and is not in the middle. Everything is done on the server side. –  DenisT Feb 21 at 20:44
    
Thanks for the information DenisT. –  Andy Feb 21 at 22:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.