将一个或多个表从一个SQL服务器传输到另一个SQL服务器的最佳方法是什么？

I have been developing in VB.NET and SQL Server 2008 for a while now, but haven't got into live installs yet. In the database system I used be on it had the ability to archive multiple tables into a .dga file, as it was called. I could then restore the .dga file into another database or on another server.I have been developing in VB.NET and SQL Server