Sign inSign up

dkeshri/data-sync-receiver

By dkeshri

•Updated over 1 year ago

This Image will Subscribe to RabbitMq and Apply DbChange to Database

Image
Message queues
0

810

dkeshri/data-sync-receiver repository overview

⁠Data-Sync-Receiver

This application help to track the change in MsSql Database changes and send that changes to RabbitMq Message broker. On Start of this application it create a Table called ChangeTrackers, Which contain list of tables that will be tracked. There is hosted service which check the Database change in every 10 secs and Send that changes to RabbiMq queue (default_queue: DataSyncQueue).

⁠Installation Steps

⁠Pre-requisite

Note: Before running image need some steps to perform

⁠Step 1: Install RabbitMq. Skip this step if already installed.
docker run -d -v rabbitmqv:/var/log/rabbitmq --hostname rmq --name RabbitMqServer -p 5672:5672 -p 8080:15
672 rabbitmq:3.13-management

⁠How to use this Image

⁠Method 1

⁠Step 1

Create docker-compose.yml file on your system and put below code in that file.

services:
  data-sync-receiver:
    container_name: data-sync-receiver
    image: dkeshri/data-sync-receiver:latest
    environment:
    - ConnectionStrings__DefaultConnection=Server=host.docker.internal,1433;Database=YourOtherDatabaseName;User Id=sa;Password=YourDatabasePassword;Encrypt=False
    - RabbitMq__Port=5672
    - RabbitMq__UserName=guest
    - RabbitMq__Password=guest
    - RabbitMq__ClientProvidedName=Receiver
    - RabbitMq__Queue__Name=DataSyncQueue
    - RabbitMq__Queue__ExchangeName=DataSyncExchange
    - RabbitMq__Queue__RoutingKeysCommaSaperated=EmitterToReceiver
⁠Step 2

Run below command

docker-compose -f .\docker-compose.yml up -d

⁠Method 2

Powershell

docker run -d `
  -e RabbitMq__HostName=host.docker.internal `
  -e RabbitMq__Port=5672 `
  -e RabbitMq__UserName=guest `
  -e RabbitMq__Password=guest `
  -e RabbitMq__ClientProvidedName=Receiver `
  -e RabbitMq__Queue__Name=DataSyncQueue `
  -e RabbitMq__Queue__ExchangeName=DataSyncExchange `
  -e RabbitMq__Queue__RoutingKeysCommaSaperated=EmitterToReceiver `
  -e ConnectionStrings__DefaultConnection="Server=host.docker.internal,1433;Database=YourDatabase;User Id=sa;Password=Password;Encrypt=False" `
  --name data-sync-receiver `
  dkeshri/data-sync-receiver:latest

linux/Mac

docker run -d \
  -e RabbitMq__HostName=host.docker.internal \
  -e RabbitMq__Port=5672 \
  -e RabbitMq__UserName=guest \
  -e RabbitMq__Password=guest \
  -e RabbitMq__ClientProvidedName=Receiver \
  -e RabbitMq__Queue__Name=DataSyncQueue \
  -e RabbitMq__Queue__ExchangeName=DataSyncExchange \
  -e RabbitMq__Queue__RoutingKeysCommaSaperated=EmitterToReceiver \
  -e ConnectionStrings__DefaultConnection="Server=host.docker.internal,1433;Database=YourDatabase;User Id=sa;Password=YourPassword;Encrypt=False" \
  --name data-sync-receiver \
  dkeshri/data-sync-receiver:latest

Tag summary

Content type

Image

Digest

sha256:9de0bff7b…

Size

83.3 MB

Last updated

over 1 year ago

docker pull dkeshri/data-sync-receiver