Database management systems are the major software companies in this age. SQL Server is a RDBMS, Microsoft, and it is often used in replication sql server ,SQL Server offers the technology if replication sql server, which allows you to copy the data from different servers, the storage of data for more than a website – that is replication process or replication sql server process.
sql server 2005 replication:
Database replication can also backup a disaster recovery plan that the multiplication of data from the file server to a local database server remotely. If the primary server fails, the application can be replicated copies of data and transactions.
sql server 2005 replication can automatically save a copy of one database to another computer. Replication, you can change.
You can play with the database server and a network of the user to the server load.
Based on the introduction of sql server 2005 replication this model, you can use the SQL Server for replication and a model: the publication, distribution, agent, and other models .
Publisher
Publisher is a server where the information is present for subscription to other servers. moreover copying the data providers to determine what data has changed in the subscriber site during the synchronization are. Depending on the copying of data in different organs.
Seller
Distribution is maintained by the database distribution. in The role of distributor type replication. 2 types of distributors are in, the distance and the local dealer. Far distributor is a separate issue, and it is a distributor for sql server 2005 replication. local server is configured in such a way for publishers and distributors.
Agents
Agents, the processes are responsible for the reproduction and dissemination of information between publishers and subscribers.
Subscriber
The participants have a server that receives and processes information.
Target
It could be any database object,
Publishing Number:
The publication is a number of articles collected in a place.
Subscriptions
The order shall, on request, copies of information, or to object to the database to replicate.
Types of subscriber fees
Changes in subscription edition subscribers Push Subscription or subscription. At any moment, marking the editor responsible for the synchronization of all changes in the subsidiary, without the participants in these changes.
With the subscription to the participants than the reproduction of the editorial staff.
Transactional replication
In the commercial sql server 2005 replication, the changes are published in the editor, there are more participants gradually.
Merge Replication
Replication of these two benefits of combining the snapshot replication and transactional replication. The first photograph of the subscribers of SQL Server, and all information about the participants and the editorial level.
Reply to the Third Party Host
sql server 2005 replication can be configured to replicate data, third party supplier to the Internet. If the provider of third house dont have copy of the databases of your company. This should be done only in close cooperation with third parties, but must ensure that its publications and recommended are anonymous.
1. Develop a publisher or distributor to agree on the TCP / IP
2. Configure FTP publishing
3. creating a subscription to the FTP
