Batch Data Source Entities to Files
appRules features an unmatched number of options for migrating, replicating and synchronizing data.
The workflow activities and other modules used in this sample project are available in the following appRules Platform products:
If you are running the On-Premise, Azure Marketplace or AWS Marketplace editions, the following hosting options supported by appRules are recommended for running this sample project:
Since the appRules Host Service is automatically installed and ready to go, it is recommended that you use it for evaluating this sample project. Just point your browser to the appRules URL
The completed project is available in the appRules Samples project database. Click the "Open" toolbar button on the appRules home page to select the "Batch Data Source Entities to Files" project.
The '"Batch Data Source Entities to Files" sample project demonstrates how to use the appRules MigrateData activity to perform batch migration of entities in a data source to files in a folder.
In the sample project, a single workflow activity is configured to load tables from a SQL Database into CSV files in a folder.
Drag the MigrateData activity from the Migrate-Replicate-Synchronize module of the toolbox on to the designer and configure it as follows:
Select Source Database as the default source, and Export to Files as the data migration type.
Select the tables to be exported:
All properties required for the Target Entities collection will be automatically set for the process. You can make any required changes to suit your needs.
Run the project and the files will be created in the Output folder: