1) Your performance depends on many things.
2) For transferring data between two remote databases you have some options, like this using the SQL Management Studio data import and export features: http://msdn.microsoft.com/en-us/library/ms140052.aspx
If you check the link, you will notice, that you can configure the same data transfer as SSIS package task. You can read in this article
] how to run such a package from asp.net.