![]() In this article, we will use the JobEmpl recruiting service database to demonstrate how to create database replication in the master-to-slave direction using T-SQL. ![]() NET can be used to perform that kind of replication. And as long as data sampling is the main goal, database replication in one direction (master-to-slave) would be enough. Usually, these read-only replicas can be created with in-built DBMS tools:īut what if you don’t need the entire database but only a few tables from it? In this case, you can create replication by yourself. The first cause high load on databases and in order to reduce it, the replica of the primary database is created to perform analytical read-only queries. This might be required, for example, for the purpose of separating analytical and operative tasks. Quite often there’s a need to create a read-only replica of a SQL Server database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |