How can I export these Sql Server 2008 Tables from SqlServer A to SqlServer B?

I'm trying to export some tables from a sql database on Sql开发者_JAVA技巧Server 1. In our intranet LAN (right next to me) is a temp Sql Server I made, called SqlServer 2.

I don't want to backup the entire db and then restore that : source DB is around 30Gig.

So I try and do an EXPORT task. But some of the tables have some GEOGRAPHY fields. So the Export Task isn't working. Is there any other way?

---

if you have administrator rights on SQLServer1, you could create a linked server object on SQLServer1 that points to SQLServer2. With that relationship, you can use a four-part name to reference the tables on SQLServer2 and write an INSERT statement to push the data over.

Check out Books Online for how to set up a linked server.