UVcSQLMirror Class Documentation
UVc.SqlMirror Class Reference
Provides functionality for mirroring data from a DataSet into a SQL server table using the SqlBulkCopy class. The Mirror method performs an iterative copy over the items contained in the DataSet's Tables collection. The List IncludeTables property specifies the names of DataTable objects to include from the DataSet's Tables collection. The List IgnoreTables specifies the names of DataTable objects to exclude. If you have already specified the IncludeTables list, then an exception is thrown if you try to access the IgnoreTables list when IncludeTables.Count > 0. Similarly, an exception is thrown when you try to access IncludeTables when IgnoreTables.Count > 0.
Public Member Functions
· delegate bool PreCopyDataTableHandler (SqlMirror sqlMirror, DataTable table)
Delegate signature for the OnPreCopyDataTable event.
· void Mirror ()
Go through each data table and copy it to the target server.
Properties
· DataSet DataSource
The DataSet to copy contents of DataTables from.
· SqlBulkCopy BulkCopy
The SqlBulkCopy instance to use to perform the copy operations.
· List< string > IgnoreTables
Specifies a list of tables to ignore from DataSource when copying.
· List< string > IncludeTables
S