Splendid Replication - Getting Started

Splendid Replication
Get Started

The quickest way to get started is to request our installer. The installer will do practically everything you need to get a SplendidReplication site up and running, with the exception of installing SQL Server Express.

Minimum Requirements

  1. Windows 10 or higher, Windows Server 2012 R2 or higher.
  2. ASP.NET Core 8.0 Hosting Bundle.
  3. SQL Server Express 2008 or higher. Download SQL Server Express 2019
  4. SQL Server Management Studio. Download SQL Server Management Studio 18.10

Using the Installer

This is the same installer that we have been using for the last 20 years with our other SplendidCRM products. The goal of the installer is to do everything necessary to get the system running on whatever version of windows you are running. We typically include SQL Server Express with the installer to save you that step, but we have decided not to do that with this product. The app will do the following:
  1. Install all files for the app. This action is performed by the typical InstallShield app.
  2. Run SplendidCRM Configuration Wizard to configure Windows. This is where the real work is done.
  3. Install IIS if not already installed.
  4. Add IIS features that are required for the app.
  5. Install ASP.NET 8.0 Hosting Bundle.
  6. Add SplendidReplication application to IIS.
  7. Connect to the database. SQL Server can be remote or local, all that is important is that you can connect. You are responsible for creating the database and providing a SQL user with sufficient ownership access to create SQL objects.
  8. Create or update all tables, functions, views, procedures and/or data to run the app.


Setup

The result is a web service at http://localhost/SplendidReplication.
Login: admin@example.com
Password: admin

The first step is to create Replication Context. This is simply connection strings for Source Database to Target Database.

The second step is to Initialize the replication system on the Replication Tables page. The target database can be an empty database or a restore of the source database. The initialization process will capture the tables in the source database and create those same tables in the target database if they do not already exist.

A typical table will go through the following stages:
Pending Create -> Pending Update -> Processing -> Complete -> Verifying -> Verified