How to transfer a SQL Server table from one server to another

What is a good way to transfer a table from one SQL Server instance to another serv开发者_StackOverflow中文版er with an available FTP?

Use 'Generate Scripts' to script table creation and use the SSMS Tools' 'Generate Insert Statement' feature to create a script to populate the table. Simple, ad completely disconnected.

And alternative would be to backup the DB, restore it to a parallel DB on the new server, and copy from DB to DB (via SELECT INTO)

Have you tried using a linked server from server A to server B?

Here's one way (using TASKS via SSMS): http://msdn.microsoft.com/en-us/library/ms142159.aspx

Here's another way (using SSIS): http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx