I am looking for a simple way to export four tables from our internal Sql Server 2005 database ("Server A") to an external SQL Server 2005 database ("Server B"). Server A is hosted locally and Server B is hosted away from our location. I usually access it via Remote desktop. This purpose of this export is for archival processes.
1. Is this even possible?
2. Is this easy to do?
3. Is this practical? (or is there a better suggestion from getting the data from Server A to Server B)
Up to this point I have been doing a backup on Server A, emailing the backup to myself, then doing a restore on Server B. This seems inefficient. Suggestions?