Extracting Data and Loading it into an Azure SQL Database

The rpsExtractDataAzure method of the JadeDatabaseAdmin class enables you to extract and load bulk data into an Azure SQL database.

To extract and load data, run the rpsExtractDataAzure method on the secondary database as a non‑GUI or GUI application. (The following examples use an application called DoRPS.)

The following is an example of how to run the application from a batch script.

set address=localhost
set port=6021
set exeFile=jade.exe

set iniFileDir=C:\PrimaryDb
set dbDir=C:\RpsDb
set binDir=bin
set sysDir=System
set iniFile=jade.ini

start %dbDir%\%binDir%\%exeFile% path=%dbDir%\%sysDir% ini=%iniFileDir%\%iniFile% app=DoRPS schema=ErewhonInvestmentsModelSchema server=multiUser name=RPSServer

If you define an application to perform the extract and load actions, on the Define Application dialog, ensure that the Initialize Method combo box points to the application initialize method that you have defined; for example, ErewhonInvestmentsModelApp::testRPSAzureSQL.

An example of the Define Application dialog is shown in the following image.

For the rpsExtractDataAzure method, the following shows an example of the initialize method that you might specify in the Initialize Method combo box on the Define Application dialog.

testRPSAzureSQL();

constants
    AllTables="";
    ScriptFilePath="C:/Jade2022/RPSSQLScripts";
    DataFilesPath="C:/Jade2022/RPSSQLScripts";
    RDBFilePath="C:/Jade2022/RPSSQLScripts";
    RDBName="AzureRPSTestDb";
    LoadHistoricalTables=false;
    Workers=1;
    //Azure parameters
    ServerName="azure-rps-test-server.database.windows.net";

vars

    dba : JadeDatabaseAdmin;

begin
    create dba transient;
    write dba.rpsExtractDataAzure(AllTables,
                                  ScriptFilePath,
                                  DataFilesPath,
                                  RDBFilePath,
                                  RDBName,
                                  LoadHistoricalTables,
                                  ServerName,
                                  Workers,
                                  RDBName,
                                  null);
    terminate;
epilog
    delete dba;
end;

2022.0.02 and higher