CLI Cookbook: Linking a Microsoft SQL Server Database Loading from the Last Full Backup of the Source Database
Reference / Command Line Interface Guide / CLI Cookbook: Common Workflows, Tasks, and Examples / CLI Cookbook: Source Databases and dSources / CLI Cookbook: Linking a Microsoft SQL Server Database Loading from the Last Full Backup of the Source Database

This topic describes how to use the command line interface to link a SQL Server database by loading from the last full backup of the source database.

Procedure

Enter the following commands in the Delphix Engine command line interface:

/database;

link;
set type=LinkParameters;
set name=<dSource name>;
set group=<group name>;

set linkData.type=MSSqlLinkData;
set linkData.syncParameters.type=MSSqlExistingMostRecentBackupSyncParameters 
set linkData.config=<source database>;
set linkData.sharedBackupLocations="<source database backup locations>";
set linkData.pptRepository=<SQL instance on the staging server>;
set linkData.sourcingPolicy.type=SourcingPolicy;
set linkData.dbUser=<source database login with SQL authentication>;
set linkData.dbCredentials.type=PasswordCredential;
set linkData.dbCredentials.password=<password for the database login>;
set linkData.ingestionStrategy.type=<ingestion strategy type>;

commit;