The following steps walk you through the process of creating the SQL replication Distributor: Open SSMS and connect to the SQL Server instance. In Object Explorer, browse to the replication folder, right-click the Replication folder, and click Configure Distribution. Click to see full answer. Similarly, you may ask, how does replication work in SQL Server?Replication. SQL Server replication is a technology for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency and integrity of the data. In most cases, replication is a process of reproducing the data at the desired targets. what is distributor in replication SQL Server? The Distributor is a server that contains the distribution database, which stores metadata and history data for all types of replication and transactions for transactional replication. To set up replication, you must configure a Distributor. Additional disk space to store the distribution database. Consequently, what are the types of replication? Types of Replication: Snapshot replication sends the entire data set to the subscriber. Transactional replication only sends modifications to the data. Merge replication items are modified at both the publisher and subscribers. Heterogeneous replication allows access to other database products. Is SQL outdated?SQL is not outdated because still using in banking sector & others sector where data stored into table. SQL used in make program in PL/SQL and others . It’s used in making transaction in a PL/SQL. So finally its not outdated .