Replicating Downloaded Data

In today's complex computing environment, data often resides on varying storage platforms within an organization. Replication provides an efficient method of distributing data that has been imported into a SQL Server. Once data resides on a SQL Server, it can be replicated outward to other SQL Servers throughout the organization.

Several conditions must be met to ensure that imported data is properly replicated:

• The SQL Server into which the data is imported must be configured as a publisher.
• The database into which the data is imported must be authorized for publication.
• To allow publication of the table, the imported data must be placed into a table with a declared primary key.
• The import of the data must take place as a logged operation.

  This implies that either the data will be imported as individual transactions or, if a bulk load operation is performed, a user-defined index must exist on the target table to ensure that the bulk load will default to a logged mode of operation.

• If a full table publication is required, no text or image datatypes may be imported.