|
A proxy table is a local table containing metadata used to access a table on a remote database server as if it were a local table. These let you import data directly.
Use proxy tables to import data when you:
have access to remote data
want to import data directly from another database
Changes are recorded in the transaction log when you import using proxy tables. This means that if there is a media failure involving the database file, you can recover information about the changes you made from the transaction log.
Create a proxy table, and then use an INSERT statement with a SELECT clause to insert data from the remote database into a permanent table in your database.
For more information about remote data access, see Accessing Remote Data.
For more information about INSERT statements, see INSERT statement.