POST /api/CreateReplication HTTP/1.1
Host: use.your.host.name:82
X-Amz-Content-Sha256: e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
Content-Type: application/json
X-Amz-Date: 20171115T202130Z
Authorization: AWS4-HMAC-SHA256 Credential= UQOPWUVNBALABCABCABC/20171115/us-east-1/cloudbasic/aws4_request, SignedHeaders=content-length;content-type;host;x-amz-content-sha256;x-amz-date, Signature=995374189c189e8e68ed3de82c1764ca11971711fb5179eeab2b19edd883dd74

{
	"replicationMethod": "ContinuousWithAutoSeeding",
        "replicationName": "Job Name (Primary)", // Not required. This is job's friendly name, seen in UI console, Runtime Logs, Reports, Dashboard, API logs etec. //The job would have a system ID/GUID assigned. If not populated, the job will be named with a system name equal to the source DB name
	"replicateLoginsUsersAndRoles": false,
	"replicateTablesOnly": false, //default=false, true would cause only tables to be replicated (no views, stored procedures functions etc)
	"replicateViews": true, //default = true, false would cause views only to not be replicated, appear as excluded in UI Console. 
        "replicateStoredProcedures": true, //Version 13.5 and later; default = true, false would cause stored procedures only to not be replicated, appear as excluded in UI Console. 
	"parallelTablesLimit": 5,
	"rebuildIndexes": false,
	"stagingBufferType": "TempDb" //Defauult=TempDb for non-AzureSQL targets. Valid values (TempDb, ReplicaDb) 
	"tde": {
		"certificateName": null,
		"keyAlgorithm": null
	},
	"source": {
		"connectionString": "Data Source=your-source-db-server;Initial Catalog=your-source-db;Persist Security Info=False;User ID=user-name;Password=******;Connect Timeout=1280",
		"encryptDataInTransit": false,
                "changeTrackingMethod": "ChangeDataCapture",
		"changeTrackingRetentionPeriod": "2 DAYS",
		"resetChangeTracking": true,
                "userApprovalToEnableChangeTracking": true   //required if ChangeTracking or CDC is not enabled yet, or if enabled but with a different retention period
	},
	"destination": {
		"connectionString":"ConnectionString>Data Source=you-server-name.database.windows.net;Initial Catalog=your-database-name;Persist Security Info=False;User ID=user-name;Password=******;Connect Timeout=12800",
                "encryptDataInTransit": false,
                "ValidateCrossDbDependencies": true, //13.7 and above; Default = false
		"azureServerTier": "Standard S0", //applicable to target AzureSQL only
		"azureMaxDbSize": "100 MB",  //applicable to target AzureSQL only
		"replicateCompatibilityLevel": true,
                "customDbCreateScript": "
                     CREATE DATABASE [AdventureWorksLT_replica] ON PRIMARY
                     ( NAME = AdventureWorksLT_replica1, FILENAME = \"D:\\RDSDBDATA\\DATA\\AdventureWorksLT_replicadat1.mdf\", SIZE = 100000KB , MAXSIZE =                          UNLIMITED, FILEGROWTH = 10%),
                     ( NAME = AdventureWorksLT_replica2, FILENAME = \"D:\\RDSDBDATA\\DATA\\AdventureWorksLT_replicadat2.ndf\", SIZE = 100000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
                     LOG ON

                     ( NAME = AdventureWorksLT_replicalog1, FILENAME = \"D:\\RDSDBDATA\\DATA\\AdventureWorksLT_replicalog1.ldf\", SIZE = 100000KB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%),
                     ( NAME = AdventureWorksLT_replicalog2, FILENAME = \"D:\\RDSDBDATA\\DATA\\AdventureWorksLT_replicalog2.ldf\", SIZE = 100000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
                     COLLATE SQL_Latin1_General_CP1_CI_AS --RDS default collation
                     ",

                "preSeedingCustomAction": "
                     ALTER DATABASE CURRENT COLLATE SQL_Latin1_General_CP1_CI_AI;
                     ",
             
                //bellow script is recommended to be executed when target is RDS, as the initial seeding creates the replica DB, but the root RDS admin login does not automatically become db_owner, as it is not sysadmin 
                "postSeedingCustomAction": "
                     CREATE USER rdsAdmin FOR LOGIN admin;
                     EXEC sp_addrolemember ''db_owner'',''admin'';
                     "
             }
	},

        //Below tag has been deprecated in 12.322
	//"tablesToExclude": "[dbo].[table1], [myschema].[table2], [dbo].[tableN]", //deprecated in 12.322, backward compatibility maintained. 
        //Replaced by “addSourceObjectsToExclusionList”: {...“tables”: “[dbo].[Departments],[dbo].[Employees]“...}  

                                       
        
        //deprecated - to be removed - never published
        //"tablesToExcludeWithoutPk": "true", -- 12.318 and above; //incompatible with
                                                                 //“tablesToExcludeWithoutUniqueIndexWithoutPk”,“tablesToExcludeWithUniqueIndexWithoutPk” 

        //12.322 and above
        //Optional Tag Group; All tags within the group are optional 
        “addSourceObjectsToExclusionList”: {
           //object=tables
           “tables”: “[dbo].[table1],[dbo].[table2],[dbo].[tableN]“,
           “tablesWithoutPk”: “true”, //incompatible with “tablesWithoutUniqueIndexWithoutPk”,“tablesWithUniqueIndexWithoutPk”
           “tablesWithoutUniqueIndexWithoutPk”: “true”, //incompatible with tablesWithoutPk”
           “tablesWithUniqueIndexWithoutPk”: “true”, //incompatible with tablesWithoutPk”
           “tablesWithBinaryColumnTypes”: “true”, //allows exclusion of tables with column types (varbinary, binary, image, geometry)
           “tablesMatchingRules”: “^\\[dbo\\].\\[archived_*]$, ^\\[dbo\\].\\[OLD_*]$, ^\\[dbo\\].\\[temp_*]$“, 
           //object=views
           “views”: “[dbo].[view1], [dbo].[vw_view2], [dbo].[vw_viewN]“,
           “viewsMatchingRules”: “^\\[dbo\\].\\[vw_archived_*]$, ^\\[dbo\\].\\[vw_old_*]$, ^\\[dbo\\].\\[vw_temp_*]$“,
           //object=SP
           “storedProcedures”: “[dbo].[sp_storedproc1],[dbo].[sp_storedproc2], [dbo].[sp_storedprocN]"
        }
        //Optional tag group
	"reseedingSchedule": {
		"tablesToIncludeWithoutPk": "[dbo].[TableWithoutpk1], [dbo].[TableWithoutpk2], [dbo].[TableWithoutPkN]",
		"tablesToIncludeWithPk": [dbo].[TableWithPk1], [dbo].[TableWithPk2], [dbo].[TableWithPkN]",
		"fromTime": "10:00:00 AM",
		"toTime": "10:59:59 PM",
		"repeatIntervalInMinutes": "100",
		"processTimeoutInMinutes": "40",
		"serializedProcessTimeoutInMinutes": "40",
		"autoSerializedProcessTimeoutInMinutes": "40"
	},
        //Optional tag group
	"RebuildDbReplicaIndexesSchedule: {
		"enabled": true,
		"recurrence": "Weekly",
		"weekDays": "Saturday",
		"fromTime": "12:00:00 AM",
		"toTime": "12:15:59 AM",
		"parallelIndexesRebuildLimit": 10
	}
}

HTTP/1.1 200
status: 200
{
	"replicationId": "594ed5c8-e0aa-4fd0-987f-fcfd2aaf1763",
	"status": "Running",
	"note": ""
}

HTTP/1.1 400
status: 400

{
    "errors": [
        "{Destination\ConnectionString}:The database must not exist. It will be created by the replication process. Delete the database or use a different name."
    ],
    "requestId": "21"
}