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

Question

I am trying to export some tables from sql database to SqlServer 1. In our local intranet network (next to me) a temp Sql server was created, which I named SqlServer 2.

I do not want to backup all db, and then restore: the original database is about 30Gig.

So, I am trying to complete the EXPORT task. But some tables have some geography fields. Therefore, the export task does not work. Is there another way?

Answer 1

If you have administrator rights to SQLServer1, you can create a related server object to SQLServer1 that points to SQLServer2. With this relationship, you can use a four-part name to refer to tables in SQLServer2 and write an INSERT statement to transfer data.

Check out Books on the Internet on how to set up a linked server.