Replication Script Editor

Use this editor to write a script that is run when a specific event occurs during replication. The script should consist of one or more functions selected from the drop-down lists at the top of the Editor.  The drop-down list on the left displays the categories for which you can define an event handler. The Editor provides editing and formatting features that include automatic indentation, automatic coloring for syntax, numeric values, comments, "code folding", and keyboard shortcuts.

The right drop-down list displays a list of appropriate events for which you can write a script. If no function was selected from the left side, the list remains empty.

The default Visual Basic template content of the Replication Script Editor looks as follows. However, it is possible to write the script using C# instead of Visual Basic by setting the scripting language in the Global Script Editor, accessible from the right mouse button menu on the metadata.

Imports Microsoft.VisualBasic
Imports DBMotoPublic
Imports DBMotoScript
Imports DBRS.GlobalScript
Namespace DBRS
    Public Class ReplicationScript : Inherits IReplicationScript
    End Class
End Namespace

When you choose an event to add to the script, it is always added directly below the ReplicationScript class as in the example below.

Imports Microsoft.VisualBasic
Imports DBMotoPublic
Imports DBMotoScript
Imports DBRS.GlobalScript
Namespace DBRS
    Public Class ReplicationScript : Inherits IReplicationScript
        Public Overrides Sub Record_onBeforeMapping(recSource As IRecord, ByRef AbortRecord As Boolean)
            
        End Sub
    End Class
End Namespace

Add code to manage the event. You can include functions from other libraries in the script code, but be sure to add the library to the list of Imports, add the library location using the References dialog and set up a namespace for the library. You can access the References dialog by clicking in the toolbar below the script.

	Checks the script syntax. If you do not do this in the script editor, you may encounter errors when the replication is running.
	Opens the Expression Generator
	Opens the References dialog so that you can add the location of any dlls that you are using from your script. You typically need to add dlls to the References dialog and to the script Imports when they do not belong to the default Microsoft .NET environment.
	Creates a comment for selected text
	Uncomments selected text

Editing and Formatting Features

• Automatic indentation based on syntax

• Colors to identify specific code elements: syntax in blue, numeric values in pink and comments in green

• Code folding where sections of code can be collapsed or expanded for ease of reading. The editor displays a green bar on the left side with +/- signs. Click - to collapse a section of code, and click + to expand a section of code.

• Common editing operations using keystroke combinations:

Opening the Replication Script Editor

On the Replication Properties dialog General tab, check the Use Script option. Click Script to open the Replication Script Editor.

Related Topics

Writing Scripts with Visual Basic .NET

Writing a Replication Script

Replication Script Events

Replication Script Properties