Multiple data replication with SQL Server

You might want to explore ways to take advantage of different kinds of replication for a variety of reasons, but probably the biggest reason is to allow administrators to provide SQL Servers to customers, and those customers ' companies are investing a lot in other data systems.

SQL Server allows you to replicate data from any resource that you can link through a 32-bit ODBC driver. For Windows 2000,nt and even Windows 98来, you can use OLE DB drivers. Therefore, you can use SQL Server to replicate various data resources, such as DB2 as400,db2/mvs,oracle,exchange and access. You can also copy data in different SQL Server versions, even between Windows CE.

For the release of different kinds of data using ODBC or OLE DB, you can request an order from the issuer. The subscribers here can be any of the data resources mentioned above. You can also order data from a variety of resources through a SQL Server.

Replication can be published as a simple impression or as a set of processing records. You might want to take advantage of this configuration when using SQL Server as a data analysis tool. The SQL Server can collect all records through replication, then pass the data to the consolidated database, or use the SQL Server profiling service as a faceted database.

When performing multiple replication configurations, you need to compile replication Distributor interface programs through SQL-DMO or Third-party replication. To see how to replicate using a variety of data resources and multiple program options, you can refer to the Microsoft MSDN troubleshooter.