Evaluating bids

Setup Transactional Replication on Sql Server / Configuración de la Replicación Transaccional en Sql Server

Published on the December 28, 2023 in IT & Programming

About this project

Open

(spanish version below)
help setup transactional replication between an on-premises sql server 2012 standard database and a sql server 2016 database hosted on amazon web services.

*Schema Structure and Sizing*
1. Schemas are identical
2. All tables must be replicated.
3. Database size is about 10GB (including documents) 

*Tasks*
1. Create a brief implementation plan
2. Create a SQL script to setup the replication environment.
3. Setup email alerts to monitor replication health.
4. Setup database and log backups.
5. Make sure the database log does not grow uncontrollably.
6. Setup Transactional Replication on SQL Server

Objective:
Help setup transactional replication between an on-premises SQL Server 2012 Standard database and a SQL Server 2016 database hosted on Amazon Web Services.
Schema Structure and Sizing
1.    Schemas are identical
2.    All tables must be replicated.
3.    Database size is about 10GB (including documents) 

Tasks
1.    Create a brief implementation plan
2.    Create a SQL script to setup the replication environment.
3.    Setup email alerts to monitor replication health.
4.    Setup database and log backups.
5.    Make sure the database log does not grow uncontrollably.
6.    Set security settings on aws 

spanish version ------
configuración de la replicación transaccional en sql server

objetivo:
ayudar a configurar la replicación transaccional entre una base de datos sql server 2012 standard local y una base de datos sql server 2016 alojada en amazon web services.

Estructura y Dimensionamiento del Esquema
1. Los esquemas son idénticos.
2. Todas las tablas deben replicarse.
3. El tamaño de la base de datos es de aproximadamente 10GB (incluyendo documentos).

Tareas
1. Crear un breve plan de implementación.
2. Crear un script SQL para configurar el entorno de replicación.
3. Configurar alertas por correo electrónico para monitorear la salud de la replicación.
4. Configurar copias de seguridad de la base de datos y del registro.
5. Asegurarse de que el registro de la base de datos no crezca de manera incontrolada.
6. Establecer la seguridad en AWS

Category IT & Programming
Subcategory Desktop apps
What is the scope of the project? Small change or bug
Is this a project or a position? Project
I currently have Not applicable
Required availability As needed
Required platforms Windows

Delivery term: December 03, 2023

Skills needed