Simplicity Bulk Copy App.

Great things can be achieved with the right tools.

Simplicity's suite of utilities and processes that provide the mechanisms for moving, consolidating and distributing data to meet your businesses automation and workflow requirements.

This section will provide you with a brief understanding and knowledge of these components and a quick reference to aid you in your Simplicity development.

Overview.

The bulk copy service allows for fast efficient movement of data tables or views from one database to another.
This service allows for the transformation of the table / view names and the creation of indexes on the created tables in the destination database.

Emails may be configured to be sent for successful and/or failure of each bulk processing job.
Whilst this service is primarily used to transfer data between databases and servers it is commonly used to transform data within the same database.

Creation of fast indexed tables from slow processor intensive analytical views for excellent runtime performance is the key benefit from using this bulk copy service. This vastly reduces processor and disk loading when querying analytical data.
The service is typically run as a scheduled process but may be executed manually.

Execution Options.

This process can be executed with the following two parameters

• /s

• Includes subdirectories to the application when looking for configuration files.

• /cfilter:wildcard string

• Only includes configuration files that match the wildcard string

• /editor

• Use the built in configuration editor to create your XML configuration file
• 

   

  

Service Setup & Configuration.

Multiple configuration documents can be present in either the same directory as the executable or in any sub directory to the executable if the /s switch is used to include subdirectories in the processing.

~SAMPLE.XML

The following is a sample of a bulk copy configuration file. The placeholders shown need to be replaced with actual values.

~SAMPLE EMAIL

The following is a sample of an email generated from the bulk copy utility.

Service Workflow.

The bulk copy dataflow model is very simple. Data is transferred through the machine running the bulk copy service at an extremely fast rate. This service can be run on the SQL Server machine if required but is typically run from a separate machine.