aboutsummaryrefslogtreecommitdiffstats
path: root/Software
diff options
context:
space:
mode:
authorRoy Ben-Shabat <Roy@Twine-s.com>2018-08-02 18:58:54 +0300
committerRoy Ben-Shabat <Roy@Twine-s.com>2018-08-02 18:58:54 +0300
commit6d54a5d28753a675cca9bb57549dbc75986be118 (patch)
tree20654ce74d8f1ee0e036f8f1f1aa0292e3ee3aba /Software
parent5efe56d0d4b2f4acd8cc275670955d68b7e196cf (diff)
downloadTango-6d54a5d28753a675cca9bb57549dbc75986be118.tar.gz
Tango-6d54a5d28753a675cca9bb57549dbc75986be118.zip
Working on SQL Examiner Library...
Diffstat (limited to 'Software')
-rw-r--r--Software/DB/SQLExaminer Projects/Override Tables.sdeproj1470
-rw-r--r--Software/DB/SQLExaminer Projects/Provision Machine.sdeproj1470
-rw-r--r--Software/DB/Tango.mdfbin75497472 -> 75497472 bytes
-rw-r--r--Software/DB/Tango_log.ldfbin1835008 -> 1835008 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Action.cs29
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs18
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Column.cs17
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs18
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs30
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs83
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs89
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs14
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Filter.cs18
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs21
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs15
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Object.cs31
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs23
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Objects.cs24
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Options.cs27
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs18
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs6
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Query.cs25
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs18
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml722
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml560
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xmlbin0 -> 7362 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dllbin0 -> 19240 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic1
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dllbin0 -> 423208 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dllbin0 -> 222504 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dllbin0 -> 574760 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dllbin0 -> 6030632 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dllbin0 -> 35112 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dllbin0 -> 959784 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dllbin0 -> 2925864 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dllbin0 -> 58664 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exebin0 -> 29992 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exebin0 -> 25896 bytes
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs13
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs18
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Table.cs37
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj125
-rw-r--r--Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs15
-rw-r--r--Software/Visual_Studio/Tango.sln42
44 files changed, 4997 insertions, 0 deletions
diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
new file mode 100644
index 000000000..1343686d3
--- /dev/null
+++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
@@ -0,0 +1,1470 @@
+<SqlDataExaminer version="21">
+ <Sources>
+ <Source id="1">
+ <EngineType>MsSqlServer</EngineType>
+ <StorageType>LiveDb</StorageType>
+ <ServerName>localhost\sqlexpress</ServerName>
+ <Database>Tango</Database>
+ <WinAuth>False</WinAuth>
+ <AzurePwd>False</AzurePwd>
+ <Login>Synchronizer</Login>
+ <Password>Aa123456</Password>
+ <SavePasswords>true</SavePasswords>
+ </Source>
+ <Source id="2">
+ <EngineType>MsSqlServer</EngineType>
+ <StorageType>LiveDb</StorageType>
+ <ServerName>twine.local\sqltwine</ServerName>
+ <Database>Tango</Database>
+ <WinAuth>True</WinAuth>
+ <AzurePwd>False</AzurePwd>
+ </Source>
+ </Sources>
+ <Items>
+ <Item name="dbo.ACTION_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ADDRESSES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="ADDRESS_STRING" />
+ <Column name="LOCALITY" />
+ <Column name="COUNTRY" />
+ <Column name="CITY" />
+ <Column name="STATE" />
+ <Column name="COUNTRY_CODE" />
+ <Column name="POSTAL_CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_OS_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.BRUSH_STOPS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SEGMENT_GUID" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="OFFSET_PERCENT" />
+ <Column name="STOP_INDEX" />
+ <Column name="CYAN" />
+ <Column name="MAGENTA" />
+ <Column name="YELLOW" />
+ <Column name="BLACK" />
+ <Column name="RED" />
+ <Column name="GREEN" />
+ <Column name="BLUE" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ <Column name="V0" />
+ <Column name="V1" />
+ <Column name="V2" />
+ <Column name="V3" />
+ <Column name="V4" />
+ <Column name="V5" />
+ <Column name="V6" />
+ <Column name="V7" />
+ <Column name="CORRECTED" />
+ <Column name="COLOR_CATALOG_GUID" />
+ <Column name="COLOR_CATALOG_CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CARTRIDGE_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CATS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="MACHINE_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="DATA" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CCTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="FORWARD_FILE_NAME" />
+ <Column name="INVERSE_FILE_NAME" />
+ <Column name="FORWARD_DATA" />
+ <Column name="INVERSE_DATA" />
+ <Column name="VERSION" />
+ <Column name="RML_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.COLOR_CATALOGS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="COLOR_CODE" />
+ <Column name="NAME" />
+ <Column name="COLOR_GROUP" />
+ <Column name="CYAN" />
+ <Column name="MAGENTA" />
+ <Column name="YELLOW" />
+ <Column name="BLACK" />
+ <Column name="RED" />
+ <Column name="GREEN" />
+ <Column name="BLUE" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ <Column name="V0" />
+ <Column name="V1" />
+ <Column name="V2" />
+ <Column name="V3" />
+ <Column name="V4" />
+ <Column name="V5" />
+ <Column name="V6" />
+ <Column name="V7" />
+ </Columns>
+ </Item>
+ <Item name="dbo.COLOR_SPACES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CONFIGURATIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CREATION_DATE" />
+ <Column name="APPLICATION_VERSION_GUID" />
+ <Column name="APPLICATION_OS_VERSION_GUID" />
+ <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CONTACTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="FIRST_NAME" />
+ <Column name="LAST_NAME" />
+ <Column name="FULL_NAME" />
+ <Column name="EMAIL" />
+ <Column name="PHONE_NUMBER" />
+ <Column name="FAX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CUSTOMERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.DISPENSER_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="NL_PER_PULSE" />
+ <Column name="CAPACITY" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="EVENT_TYPES_CATEGORY_GUID" />
+ <Column name="EVENT_TYPES_GROUP_GUID" />
+ <Column name="REQUIRES_USER_INTERVENTION" />
+ <Column name="HTML_PAGE_GUID" />
+ <Column name="RESOLVABLE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES_ACTIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="EVENT_TYPE_GUID" />
+ <Column name="ACTION_TYPE_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES_GROUPS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.FIBER_SHAPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.FIBER_SYNTHS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_DANCERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_DANCER_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="GRADUAL" />
+ <Column name="K" />
+ <Column name="X" />
+ <Column name="PULSE_PER_MM_SPRING" />
+ <Column name="MAXIMAL_MOVEMENT_MM" />
+ <Column name="ZERO_POINT" />
+ <Column name="RESOLUTION_BITS" />
+ <Column name="ARM_LENGTH" />
+ <Column name="ASSEMBLY_DIRECTION_RIGHT" />
+ <Column name="ACCELERATE_ON_TENSION_RAISE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="SUPPORTS_HOMING" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_MOTORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_MOTOR_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="MIN_FREQUENCY" />
+ <Column name="MAX_FREQUENCY" />
+ <Column name="SET_MICRO_STEP" />
+ <Column name="MICRO_STEP" />
+ <Column name="MAX_CHANGE_SLOPE" />
+ <Column name="HIGH_LENGTH_MICRO_SECOND" />
+ <Column name="SPEED_MASTER" />
+ <Column name="PULSE_PER_ROUND" />
+ <Column name="PULLEY_RADIUS" />
+ <Column name="CONFIG_WORD" />
+ <Column name="DIRECTION_THREAD_WIZE" />
+ <Column name="KVAL_HOLD" />
+ <Column name="KVAL_RUN" />
+ <Column name="KVAL_ACC" />
+ <Column name="KVAL_DEC" />
+ <Column name="OVER_CURRENT_THRESHOLD" />
+ <Column name="STALL_THRESHOLD" />
+ <Column name="THERMAL_COMPENSATION_FACTOR" />
+ <Column name="LOW_SPEED_OPTIMIZATION" />
+ <Column name="ST_SLP" />
+ <Column name="INT_SPD" />
+ <Column name="FN_SLP_ACC" />
+ <Column name="FN_SLP_DEC" />
+ <Column name="FS_SPD" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_PID_CONTROLS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" />
+ <Column name="OUTPUT_PROPORTIONAL_BAND" />
+ <Column name="INTEGRAL_TIME" />
+ <Column name="DERIVATIVE_TIME" />
+ <Column name="SENSOR_CORRECTION_ADJUSTMENT" />
+ <Column name="SENSOR_MIN_VALUE" />
+ <Column name="SENSOR_MAX_VALUE" />
+ <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" />
+ <Column name="SET_POINT_CONTROL_OUTPUT_RATE" />
+ <Column name="CONTROL_OUTPUT_TYPE" />
+ <Column name="SSR_CONTROL_OUTPUT_TYPE" />
+ <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" />
+ <Column name="PROCESS_VARIABLE_SAMPLING_RATE" />
+ <Column name="PV_INPUT_FILTER_FACTOR_MODE" />
+ <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
+ <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
+ <Column name="PROPORTIONAL_GAIN" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="RESOLUTION_BITS" />
+ <Column name="PERIMETER" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_WINDER_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_WINDERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_WINDER_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="MILLIMETER_PER_ROTATION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HTML_PAGES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="HTML" />
+ </Columns>
+ </Item>
+ <Item name="dbo.IDS_PACK_FORMULAS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="AUTO_CALCULATED" />
+ </Columns>
+ </Item>
+ <Item name="dbo.IDS_PACKS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="DISPENSER_TYPE_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="CARTRIDGE_TYPE_GUID" />
+ <Column name="MID_TANK_TYPE_GUID" />
+ <Column name="IDS_PACK_FORMULA_GUID" />
+ <Column name="NAME" />
+ <Column name="PACK_INDEX" />
+ <Column name="IS_EMPTY" />
+ </Columns>
+ </Item>
+ <Item name="dbo.JOB_RUNS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="JOB_GUID" />
+ <Column name="START_DATE" />
+ <Column name="END_DATE" />
+ <Column name="SUCCESSFUL" />
+ </Columns>
+ </Item>
+ <Item name="dbo.JOBS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CREATION_DATE" />
+ <Column name="LAST_RUN" />
+ <Column name="MACHINE_GUID" />
+ <Column name="USER_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="WINDING_METHOD_GUID" />
+ <Column name="SPOOL_TYPE_GUID" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="INTER_SEGMENT_LENGTH" />
+ <Column name="ENABLE_INTER_SEGMENT" />
+ <Column name="ENABLE_LUBRICATION" />
+ <Column name="JOB_INDEX" />
+ <Column name="ESTIMATED_DURATION_MILI" />
+ <Column name="HAS_EMBROIDERY_FILE" />
+ <Column name="EMBROIDERY_FILE_DATA" />
+ <Column name="EMBROIDERY_FILE_NAME" />
+ <Column name="EMBROIDERY_JPEG" />
+ <Column name="STATUS" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="NUMBER_OF_UNITS" />
+ <Column name="TYPE" />
+ <Column name="CUSTOMER_GUID" />
+ <Column name="SPOOLS_DISTRIBUTION" />
+ <Column name="NUMBER_OF_HEADS" />
+ <Column name="SAMPLE_UNITS_OR_METERS" />
+ <Column name="FINE_TUNING_STATUS" />
+ <Column name="FINE_TUNING_APPROVE_DATE" />
+ <Column name="SAMPLE_DYE_STATUS" />
+ <Column name="SAMPLE_DYE_APPROVE_DATE" />
+ <Column name="EDITING_STATE" />
+ <Column name="LENGTH_PERCENTAGE_FACTOR" />
+ </Columns>
+ </Item>
+ <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.LIQUID_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="VERSION" />
+ <Column name="COLOR" />
+ </Columns>
+ </Item>
+ <Item name="dbo.LIQUID_TYPES_RMLS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="MAX_NL_PER_CM" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="FTP_FILE_PATH" />
+ <Column name="COMMENTS" />
+ <Column name="USER_GUID" />
+ <Column name="FORCE_UPDATE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ <Column name="DEFAULT_CONFIGURATION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SERIAL_NUMBER" />
+ <Column name="NAME" />
+ <Column name="PRODUCTION_DATE" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="MACHINE_VERSION_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="ENABLE_EXTERNAL_BRIDGE" />
+ <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+ <Column name="DEFAULT_RML_GUID" />
+ <Column name="TARGET_JOB_TYPES" />
+ <Column name="DEFAULT_COLOR_SPACE_GUID" />
+ <Column name="DEFAULT_SEGMENT_LENGTH" />
+ <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+ <Column name="SYNCHED" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="MACHINE_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES_EVENTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HOST_NAME" />
+ <Column name="MACHINE_GUID" />
+ <Column name="EVENT_TYPE_GUID" />
+ <Column name="USER_GUID" />
+ <Column name="DATE_TIME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES_EVENTS_VIEW" type="view">
+ <Columns>
+ <Column name="DATE" />
+ <Column name="MACHINE" />
+ <Column name="USER_NAME" />
+ <Column name="GROUP" />
+ <Column name="CATEGORY" />
+ <Column name="TYPE" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_COLORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_CONDITIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_MATERIALS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_PURPOSES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MID_TANK_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="LITER_CAPACITY" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ORGANIZATIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.PERMISSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="DYEING_SPEED" />
+ <Column name="MIN_INK_UPTAKE" />
+ <Column name="FEEDER_TENSION" />
+ <Column name="PULLER_TENSION" />
+ <Column name="WINDER_TENSION" />
+ <Column name="MIXER_TEMP" />
+ <Column name="HEAD_ZONE1_TEMP" />
+ <Column name="HEAD_ZONE2_TEMP" />
+ <Column name="HEAD_ZONE3_TEMP" />
+ <Column name="HEAD_ZONE4_TEMP" />
+ <Column name="HEAD_ZONE5_TEMP" />
+ <Column name="HEAD_ZONE6_TEMP" />
+ <Column name="DRYER_AIR_FLOW" />
+ <Column name="DRYER_ZONE1_TEMP" />
+ <Column name="DRYER_ZONE2_TEMP" />
+ <Column name="DRYER_ZONE3_TEMP" />
+ <Column name="DRYER_BUFFER_LENGTH" />
+ <Column name="HEAD_AIR_FLOW" />
+ <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
+ <Column name="TABLE_INDEX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="RML_GUID" />
+ <Column name="NAME" />
+ <Column name="ACTIVE" />
+ <Column name="SAVE_DATE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.RMLS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="MANUFACTURER" />
+ <Column name="CODE" />
+ <Column name="MEDIA_MATERIAL_GUID" />
+ <Column name="MEDIA_COLOR_GUID" />
+ <Column name="MEDIA_PURPOSE_GUID" />
+ <Column name="MEDIA_CONDITION_GUID" />
+ <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" />
+ <Column name="FIBER_SHAPE_GUID" />
+ <Column name="FIBER_SYNTH_GUID" />
+ <Column name="FIBER_SIZE" />
+ <Column name="NUMBER_OF_FIBERS" />
+ <Column name="PLIES_PER_FIBER" />
+ <Column name="PLIES_PER_THREAD" />
+ <Column name="TWISTED" />
+ <Column name="AIR_ENTANGLEMENT" />
+ <Column name="LUBRICANT" />
+ <Column name="TENSILE_STRENGTH" />
+ <Column name="ELONGATION_AT_BREAK_PERCENTAGE" />
+ <Column name="ESTIMATED_THREAD_DIAMETER" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ROLES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ROLES_PERMISSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="ROLE_GUID" />
+ <Column name="PERMISSION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.SEGMENTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="JOB_GUID" />
+ <Column name="LENGTH" />
+ <Column name="SEGMENT_INDEX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.SPOOL_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="LENGTH" />
+ <Column name="WEIGHT" />
+ <Column name="DIAMETER" />
+ <Column name="START_OFFSET_PULSES" />
+ <Column name="BACKING_RATE" />
+ <Column name="SEGMENT_OFFSET_PULSES" />
+ <Column name="BOTTOM_BACKING_RATE" />
+ <Column name="ROTATIONS_PER_PASSAGE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.SYNC_CONFIGURATIONS" type="table">
+ <Columns>
+ <Column name="ID" key="true" />
+ <Column name="TABLE_NAME" />
+ <Column name="SYNC_TYPE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_CONTROLLERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ <Column name="UNITS" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_DISPENSERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_IOS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="PORT" />
+ <Column name="TYPE" />
+ <Column name="DESIGNATOR" />
+ <Column name="ASM" />
+ <Column name="INTERFACE_NAME" />
+ <Column name="SENSOR" />
+ <Column name="INIT_VALUE" />
+ <Column name="AVERAGING" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_MONITORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ <Column name="UNITS" />
+ <Column name="POINTS_PER_FRAME" />
+ <Column name="MULTI_CHANNEL" />
+ <Column name="CHANNEL_COUNT" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_VALVES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.USERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="EMAIL" />
+ <Column name="PASSWORD" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ <Column name="LAST_LOGIN" />
+ </Columns>
+ </Item>
+ <Item name="dbo.USERS_ROLES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="USER_GUID" />
+ <Column name="ROLE_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.WINDING_METHODS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="Sync_Addresses" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="ADDRESS_STRING" />
+ <Column name="LOCALITY" />
+ <Column name="COUNTRY" />
+ <Column name="CITY" />
+ <Column name="STATE" />
+ <Column name="COUNTRY_CODE" />
+ <Column name="POSTAL_CODE" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="ADDRESS_STRING" />
+ <UpdateColumn name="LOCALITY" />
+ <UpdateColumn name="COUNTRY" />
+ <UpdateColumn name="CITY" />
+ <UpdateColumn name="STATE" />
+ <UpdateColumn name="COUNTRY_CODE" />
+ <UpdateColumn name="POSTAL_CODE" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="ADDRESS_STRING" />
+ <UpdateColumn name="LOCALITY" />
+ <UpdateColumn name="COUNTRY" />
+ <UpdateColumn name="CITY" />
+ <UpdateColumn name="STATE" />
+ <UpdateColumn name="COUNTRY_CODE" />
+ <UpdateColumn name="POSTAL_CODE" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Configuration" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CREATION_DATE" />
+ <Column name="APPLICATION_VERSION_GUID" />
+ <Column name="APPLICATION_OS_VERSION_GUID" />
+ <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CREATION_DATE" />
+ <UpdateColumn name="APPLICATION_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <UpdateColumn name="HARDWARE_VERSION_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CREATION_DATE" />
+ <UpdateColumn name="APPLICATION_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <UpdateColumn name="HARDWARE_VERSION_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Contacts" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="FIRST_NAME" />
+ <Column name="LAST_NAME" />
+ <Column name="FULL_NAME" />
+ <Column name="EMAIL" />
+ <Column name="PHONE_NUMBER" />
+ <Column name="FAX" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="FIRST_NAME" />
+ <UpdateColumn name="LAST_NAME" />
+ <UpdateColumn name="FULL_NAME" />
+ <UpdateColumn name="EMAIL" />
+ <UpdateColumn name="PHONE_NUMBER" />
+ <UpdateColumn name="FAX" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="FIRST_NAME" />
+ <UpdateColumn name="LAST_NAME" />
+ <UpdateColumn name="FULL_NAME" />
+ <UpdateColumn name="EMAIL" />
+ <UpdateColumn name="PHONE_NUMBER" />
+ <UpdateColumn name="FAX" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_IdsPacks" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="DISPENSER_TYPE_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="CARTRIDGE_TYPE_GUID" />
+ <Column name="MID_TANK_TYPE_GUID" />
+ <Column name="IDS_PACK_FORMULA_GUID" />
+ <Column name="NAME" />
+ <Column name="PACK_INDEX" />
+ <Column name="IS_EMPTY" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES
+ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+ INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES
+ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+ INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="DISPENSER_TYPE_GUID" />
+ <UpdateColumn name="LIQUID_TYPE_GUID" />
+ <UpdateColumn name="CARTRIDGE_TYPE_GUID" />
+ <UpdateColumn name="MID_TANK_TYPE_GUID" />
+ <UpdateColumn name="IDS_PACK_FORMULA_GUID" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PACK_INDEX" />
+ <UpdateColumn name="IS_EMPTY" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Machine" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SERIAL_NUMBER" />
+ <Column name="NAME" />
+ <Column name="PRODUCTION_DATE" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="MACHINE_VERSION_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="ENABLE_EXTERNAL_BRIDGE" />
+ <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+ <Column name="DEFAULT_RML_GUID" />
+ <Column name="TARGET_JOB_TYPES" />
+ <Column name="DEFAULT_COLOR_SPACE_GUID" />
+ <Column name="DEFAULT_SEGMENT_LENGTH" />
+ <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+ <Column name="SYNCHED" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="SERIAL_NUMBER" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PRODUCTION_DATE" />
+ <UpdateColumn name="ORGANIZATION_GUID" />
+ <UpdateColumn name="MACHINE_VERSION_GUID" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+ <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+ <UpdateColumn name="DEFAULT_RML_GUID" />
+ <UpdateColumn name="TARGET_JOB_TYPES" />
+ <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+ <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+ <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+ <UpdateColumn name="SYNCHED" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="SERIAL_NUMBER" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PRODUCTION_DATE" />
+ <UpdateColumn name="ORGANIZATION_GUID" />
+ <UpdateColumn name="MACHINE_VERSION_GUID" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+ <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+ <UpdateColumn name="DEFAULT_RML_GUID" />
+ <UpdateColumn name="TARGET_JOB_TYPES" />
+ <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+ <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+ <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+ <UpdateColumn name="SYNCHED" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Organization" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CONTACT_GUID" />
+ <UpdateColumn name="ADDRESS_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CONTACT_GUID" />
+ <UpdateColumn name="ADDRESS_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_UsersRoles" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="USER_GUID" />
+ <Column name="ROLE_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="USER_GUID" />
+ <UpdateColumn name="ROLE_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="USER_GUID" />
+ <UpdateColumn name="ROLE_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ </Items>
+ <SchemaMapping>
+ <SMItem schema1="dbo" schema2="dbo" />
+ </SchemaMapping>
+ <ProjectSettings>
+ <AllSettings>
+ <ComparisonCaseSensitive>1</ComparisonCaseSensitive>
+ <CompareTrimmedStrings>False</CompareTrimmedStrings>
+ <EmptyEqualsNull>False</EmptyEqualsNull>
+ <PrecedeStringConstWithNPrefix>0</PrecedeStringConstWithNPrefix>
+ <AutoSelectKeyColumns>0</AutoSelectKeyColumns>
+ <PerformanceOptions>
+ <PerformanceOption name="Auto" value="True" />
+ </PerformanceOptions>
+ </AllSettings>
+ </ProjectSettings>
+</SqlDataExaminer> \ No newline at end of file
diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
new file mode 100644
index 000000000..1343686d3
--- /dev/null
+++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
@@ -0,0 +1,1470 @@
+<SqlDataExaminer version="21">
+ <Sources>
+ <Source id="1">
+ <EngineType>MsSqlServer</EngineType>
+ <StorageType>LiveDb</StorageType>
+ <ServerName>localhost\sqlexpress</ServerName>
+ <Database>Tango</Database>
+ <WinAuth>False</WinAuth>
+ <AzurePwd>False</AzurePwd>
+ <Login>Synchronizer</Login>
+ <Password>Aa123456</Password>
+ <SavePasswords>true</SavePasswords>
+ </Source>
+ <Source id="2">
+ <EngineType>MsSqlServer</EngineType>
+ <StorageType>LiveDb</StorageType>
+ <ServerName>twine.local\sqltwine</ServerName>
+ <Database>Tango</Database>
+ <WinAuth>True</WinAuth>
+ <AzurePwd>False</AzurePwd>
+ </Source>
+ </Sources>
+ <Items>
+ <Item name="dbo.ACTION_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ADDRESSES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="ADDRESS_STRING" />
+ <Column name="LOCALITY" />
+ <Column name="COUNTRY" />
+ <Column name="CITY" />
+ <Column name="STATE" />
+ <Column name="COUNTRY_CODE" />
+ <Column name="POSTAL_CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_OS_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.APPLICATION_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.BRUSH_STOPS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SEGMENT_GUID" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="OFFSET_PERCENT" />
+ <Column name="STOP_INDEX" />
+ <Column name="CYAN" />
+ <Column name="MAGENTA" />
+ <Column name="YELLOW" />
+ <Column name="BLACK" />
+ <Column name="RED" />
+ <Column name="GREEN" />
+ <Column name="BLUE" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ <Column name="V0" />
+ <Column name="V1" />
+ <Column name="V2" />
+ <Column name="V3" />
+ <Column name="V4" />
+ <Column name="V5" />
+ <Column name="V6" />
+ <Column name="V7" />
+ <Column name="CORRECTED" />
+ <Column name="COLOR_CATALOG_GUID" />
+ <Column name="COLOR_CATALOG_CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CARTRIDGE_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CATS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="MACHINE_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="DATA" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CCTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="FORWARD_FILE_NAME" />
+ <Column name="INVERSE_FILE_NAME" />
+ <Column name="FORWARD_DATA" />
+ <Column name="INVERSE_DATA" />
+ <Column name="VERSION" />
+ <Column name="RML_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.COLOR_CATALOGS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="COLOR_CODE" />
+ <Column name="NAME" />
+ <Column name="COLOR_GROUP" />
+ <Column name="CYAN" />
+ <Column name="MAGENTA" />
+ <Column name="YELLOW" />
+ <Column name="BLACK" />
+ <Column name="RED" />
+ <Column name="GREEN" />
+ <Column name="BLUE" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ <Column name="V0" />
+ <Column name="V1" />
+ <Column name="V2" />
+ <Column name="V3" />
+ <Column name="V4" />
+ <Column name="V5" />
+ <Column name="V6" />
+ <Column name="V7" />
+ </Columns>
+ </Item>
+ <Item name="dbo.COLOR_SPACES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CONFIGURATIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CREATION_DATE" />
+ <Column name="APPLICATION_VERSION_GUID" />
+ <Column name="APPLICATION_OS_VERSION_GUID" />
+ <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CONTACTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="FIRST_NAME" />
+ <Column name="LAST_NAME" />
+ <Column name="FULL_NAME" />
+ <Column name="EMAIL" />
+ <Column name="PHONE_NUMBER" />
+ <Column name="FAX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.CUSTOMERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.DISPENSER_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="NL_PER_PULSE" />
+ <Column name="CAPACITY" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="EVENT_TYPES_CATEGORY_GUID" />
+ <Column name="EVENT_TYPES_GROUP_GUID" />
+ <Column name="REQUIRES_USER_INTERVENTION" />
+ <Column name="HTML_PAGE_GUID" />
+ <Column name="RESOLVABLE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES_ACTIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="EVENT_TYPE_GUID" />
+ <Column name="ACTION_TYPE_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.EVENT_TYPES_GROUPS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.FIBER_SHAPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.FIBER_SYNTHS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_DANCERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_DANCER_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="GRADUAL" />
+ <Column name="K" />
+ <Column name="X" />
+ <Column name="PULSE_PER_MM_SPRING" />
+ <Column name="MAXIMAL_MOVEMENT_MM" />
+ <Column name="ZERO_POINT" />
+ <Column name="RESOLUTION_BITS" />
+ <Column name="ARM_LENGTH" />
+ <Column name="ASSEMBLY_DIRECTION_RIGHT" />
+ <Column name="ACCELERATE_ON_TENSION_RAISE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="SUPPORTS_HOMING" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_MOTORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_MOTOR_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="MIN_FREQUENCY" />
+ <Column name="MAX_FREQUENCY" />
+ <Column name="SET_MICRO_STEP" />
+ <Column name="MICRO_STEP" />
+ <Column name="MAX_CHANGE_SLOPE" />
+ <Column name="HIGH_LENGTH_MICRO_SECOND" />
+ <Column name="SPEED_MASTER" />
+ <Column name="PULSE_PER_ROUND" />
+ <Column name="PULLEY_RADIUS" />
+ <Column name="CONFIG_WORD" />
+ <Column name="DIRECTION_THREAD_WIZE" />
+ <Column name="KVAL_HOLD" />
+ <Column name="KVAL_RUN" />
+ <Column name="KVAL_ACC" />
+ <Column name="KVAL_DEC" />
+ <Column name="OVER_CURRENT_THRESHOLD" />
+ <Column name="STALL_THRESHOLD" />
+ <Column name="THERMAL_COMPENSATION_FACTOR" />
+ <Column name="LOW_SPEED_OPTIMIZATION" />
+ <Column name="ST_SLP" />
+ <Column name="INT_SPD" />
+ <Column name="FN_SLP_ACC" />
+ <Column name="FN_SLP_DEC" />
+ <Column name="FS_SPD" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_PID_CONTROLS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" />
+ <Column name="OUTPUT_PROPORTIONAL_BAND" />
+ <Column name="INTEGRAL_TIME" />
+ <Column name="DERIVATIVE_TIME" />
+ <Column name="SENSOR_CORRECTION_ADJUSTMENT" />
+ <Column name="SENSOR_MIN_VALUE" />
+ <Column name="SENSOR_MAX_VALUE" />
+ <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" />
+ <Column name="SET_POINT_CONTROL_OUTPUT_RATE" />
+ <Column name="CONTROL_OUTPUT_TYPE" />
+ <Column name="SSR_CONTROL_OUTPUT_TYPE" />
+ <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" />
+ <Column name="PROCESS_VARIABLE_SAMPLING_RATE" />
+ <Column name="PV_INPUT_FILTER_FACTOR_MODE" />
+ <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
+ <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
+ <Column name="PROPORTIONAL_GAIN" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="RESOLUTION_BITS" />
+ <Column name="PERIMETER" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_WINDER_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HARDWARE_WINDERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_WINDER_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="MILLIMETER_PER_ROTATION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.HTML_PAGES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="HTML" />
+ </Columns>
+ </Item>
+ <Item name="dbo.IDS_PACK_FORMULAS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="AUTO_CALCULATED" />
+ </Columns>
+ </Item>
+ <Item name="dbo.IDS_PACKS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="DISPENSER_TYPE_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="CARTRIDGE_TYPE_GUID" />
+ <Column name="MID_TANK_TYPE_GUID" />
+ <Column name="IDS_PACK_FORMULA_GUID" />
+ <Column name="NAME" />
+ <Column name="PACK_INDEX" />
+ <Column name="IS_EMPTY" />
+ </Columns>
+ </Item>
+ <Item name="dbo.JOB_RUNS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="JOB_GUID" />
+ <Column name="START_DATE" />
+ <Column name="END_DATE" />
+ <Column name="SUCCESSFUL" />
+ </Columns>
+ </Item>
+ <Item name="dbo.JOBS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CREATION_DATE" />
+ <Column name="LAST_RUN" />
+ <Column name="MACHINE_GUID" />
+ <Column name="USER_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="WINDING_METHOD_GUID" />
+ <Column name="SPOOL_TYPE_GUID" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="INTER_SEGMENT_LENGTH" />
+ <Column name="ENABLE_INTER_SEGMENT" />
+ <Column name="ENABLE_LUBRICATION" />
+ <Column name="JOB_INDEX" />
+ <Column name="ESTIMATED_DURATION_MILI" />
+ <Column name="HAS_EMBROIDERY_FILE" />
+ <Column name="EMBROIDERY_FILE_DATA" />
+ <Column name="EMBROIDERY_FILE_NAME" />
+ <Column name="EMBROIDERY_JPEG" />
+ <Column name="STATUS" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="NUMBER_OF_UNITS" />
+ <Column name="TYPE" />
+ <Column name="CUSTOMER_GUID" />
+ <Column name="SPOOLS_DISTRIBUTION" />
+ <Column name="NUMBER_OF_HEADS" />
+ <Column name="SAMPLE_UNITS_OR_METERS" />
+ <Column name="FINE_TUNING_STATUS" />
+ <Column name="FINE_TUNING_APPROVE_DATE" />
+ <Column name="SAMPLE_DYE_STATUS" />
+ <Column name="SAMPLE_DYE_APPROVE_DATE" />
+ <Column name="EDITING_STATE" />
+ <Column name="LENGTH_PERCENTAGE_FACTOR" />
+ </Columns>
+ </Item>
+ <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.LIQUID_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="VERSION" />
+ <Column name="COLOR" />
+ </Columns>
+ </Item>
+ <Item name="dbo.LIQUID_TYPES_RMLS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="MAX_NL_PER_CM" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="FTP_FILE_PATH" />
+ <Column name="COMMENTS" />
+ <Column name="USER_GUID" />
+ <Column name="FORCE_UPDATE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINE_VERSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ <Column name="DEFAULT_CONFIGURATION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SERIAL_NUMBER" />
+ <Column name="NAME" />
+ <Column name="PRODUCTION_DATE" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="MACHINE_VERSION_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="ENABLE_EXTERNAL_BRIDGE" />
+ <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+ <Column name="DEFAULT_RML_GUID" />
+ <Column name="TARGET_JOB_TYPES" />
+ <Column name="DEFAULT_COLOR_SPACE_GUID" />
+ <Column name="DEFAULT_SEGMENT_LENGTH" />
+ <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+ <Column name="SYNCHED" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="MACHINE_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES_EVENTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HOST_NAME" />
+ <Column name="MACHINE_GUID" />
+ <Column name="EVENT_TYPE_GUID" />
+ <Column name="USER_GUID" />
+ <Column name="DATE_TIME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MACHINES_EVENTS_VIEW" type="view">
+ <Columns>
+ <Column name="DATE" />
+ <Column name="MACHINE" />
+ <Column name="USER_NAME" />
+ <Column name="GROUP" />
+ <Column name="CATEGORY" />
+ <Column name="TYPE" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_COLORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_CONDITIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_MATERIALS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MEDIA_PURPOSES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.MID_TANK_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="LITER_CAPACITY" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ORGANIZATIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.PERMISSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="DYEING_SPEED" />
+ <Column name="MIN_INK_UPTAKE" />
+ <Column name="FEEDER_TENSION" />
+ <Column name="PULLER_TENSION" />
+ <Column name="WINDER_TENSION" />
+ <Column name="MIXER_TEMP" />
+ <Column name="HEAD_ZONE1_TEMP" />
+ <Column name="HEAD_ZONE2_TEMP" />
+ <Column name="HEAD_ZONE3_TEMP" />
+ <Column name="HEAD_ZONE4_TEMP" />
+ <Column name="HEAD_ZONE5_TEMP" />
+ <Column name="HEAD_ZONE6_TEMP" />
+ <Column name="DRYER_AIR_FLOW" />
+ <Column name="DRYER_ZONE1_TEMP" />
+ <Column name="DRYER_ZONE2_TEMP" />
+ <Column name="DRYER_ZONE3_TEMP" />
+ <Column name="DRYER_BUFFER_LENGTH" />
+ <Column name="HEAD_AIR_FLOW" />
+ <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
+ <Column name="TABLE_INDEX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="RML_GUID" />
+ <Column name="NAME" />
+ <Column name="ACTIVE" />
+ <Column name="SAVE_DATE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.RMLS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="MANUFACTURER" />
+ <Column name="CODE" />
+ <Column name="MEDIA_MATERIAL_GUID" />
+ <Column name="MEDIA_COLOR_GUID" />
+ <Column name="MEDIA_PURPOSE_GUID" />
+ <Column name="MEDIA_CONDITION_GUID" />
+ <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" />
+ <Column name="FIBER_SHAPE_GUID" />
+ <Column name="FIBER_SYNTH_GUID" />
+ <Column name="FIBER_SIZE" />
+ <Column name="NUMBER_OF_FIBERS" />
+ <Column name="PLIES_PER_FIBER" />
+ <Column name="PLIES_PER_THREAD" />
+ <Column name="TWISTED" />
+ <Column name="AIR_ENTANGLEMENT" />
+ <Column name="LUBRICANT" />
+ <Column name="TENSILE_STRENGTH" />
+ <Column name="ELONGATION_AT_BREAK_PERCENTAGE" />
+ <Column name="ESTIMATED_THREAD_DIAMETER" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ROLES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.ROLES_PERMISSIONS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="ROLE_GUID" />
+ <Column name="PERMISSION_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.SEGMENTS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="JOB_GUID" />
+ <Column name="LENGTH" />
+ <Column name="SEGMENT_INDEX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.SPOOL_TYPES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="LENGTH" />
+ <Column name="WEIGHT" />
+ <Column name="DIAMETER" />
+ <Column name="START_OFFSET_PULSES" />
+ <Column name="BACKING_RATE" />
+ <Column name="SEGMENT_OFFSET_PULSES" />
+ <Column name="BOTTOM_BACKING_RATE" />
+ <Column name="ROTATIONS_PER_PASSAGE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.SYNC_CONFIGURATIONS" type="table">
+ <Columns>
+ <Column name="ID" key="true" />
+ <Column name="TABLE_NAME" />
+ <Column name="SYNC_TYPE" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_CONTROLLERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ <Column name="UNITS" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_DISPENSERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_IOS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="PORT" />
+ <Column name="TYPE" />
+ <Column name="DESIGNATOR" />
+ <Column name="ASM" />
+ <Column name="INTERFACE_NAME" />
+ <Column name="SENSOR" />
+ <Column name="INIT_VALUE" />
+ <Column name="AVERAGING" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_MONITORS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ <Column name="UNITS" />
+ <Column name="POINTS_PER_FRAME" />
+ <Column name="MULTI_CHANNEL" />
+ <Column name="CHANNEL_COUNT" />
+ </Columns>
+ </Item>
+ <Item name="dbo.TECH_VALVES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="dbo.USERS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="EMAIL" />
+ <Column name="PASSWORD" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ <Column name="LAST_LOGIN" />
+ </Columns>
+ </Item>
+ <Item name="dbo.USERS_ROLES" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="USER_GUID" />
+ <Column name="ROLE_GUID" />
+ </Columns>
+ </Item>
+ <Item name="dbo.WINDING_METHODS" type="table">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Item>
+ <Item name="Sync_Addresses" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="ADDRESS_STRING" />
+ <Column name="LOCALITY" />
+ <Column name="COUNTRY" />
+ <Column name="CITY" />
+ <Column name="STATE" />
+ <Column name="COUNTRY_CODE" />
+ <Column name="POSTAL_CODE" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="ADDRESS_STRING" />
+ <UpdateColumn name="LOCALITY" />
+ <UpdateColumn name="COUNTRY" />
+ <UpdateColumn name="CITY" />
+ <UpdateColumn name="STATE" />
+ <UpdateColumn name="COUNTRY_CODE" />
+ <UpdateColumn name="POSTAL_CODE" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="ADDRESS_STRING" />
+ <UpdateColumn name="LOCALITY" />
+ <UpdateColumn name="COUNTRY" />
+ <UpdateColumn name="CITY" />
+ <UpdateColumn name="STATE" />
+ <UpdateColumn name="COUNTRY_CODE" />
+ <UpdateColumn name="POSTAL_CODE" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Configuration" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CREATION_DATE" />
+ <Column name="APPLICATION_VERSION_GUID" />
+ <Column name="APPLICATION_OS_VERSION_GUID" />
+ <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CREATION_DATE" />
+ <UpdateColumn name="APPLICATION_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <UpdateColumn name="HARDWARE_VERSION_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CREATION_DATE" />
+ <UpdateColumn name="APPLICATION_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <UpdateColumn name="HARDWARE_VERSION_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Contacts" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="FIRST_NAME" />
+ <Column name="LAST_NAME" />
+ <Column name="FULL_NAME" />
+ <Column name="EMAIL" />
+ <Column name="PHONE_NUMBER" />
+ <Column name="FAX" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="FIRST_NAME" />
+ <UpdateColumn name="LAST_NAME" />
+ <UpdateColumn name="FULL_NAME" />
+ <UpdateColumn name="EMAIL" />
+ <UpdateColumn name="PHONE_NUMBER" />
+ <UpdateColumn name="FAX" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="FIRST_NAME" />
+ <UpdateColumn name="LAST_NAME" />
+ <UpdateColumn name="FULL_NAME" />
+ <UpdateColumn name="EMAIL" />
+ <UpdateColumn name="PHONE_NUMBER" />
+ <UpdateColumn name="FAX" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_IdsPacks" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="DISPENSER_TYPE_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="CARTRIDGE_TYPE_GUID" />
+ <Column name="MID_TANK_TYPE_GUID" />
+ <Column name="IDS_PACK_FORMULA_GUID" />
+ <Column name="NAME" />
+ <Column name="PACK_INDEX" />
+ <Column name="IS_EMPTY" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES
+ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+ INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES
+ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+ INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="DISPENSER_TYPE_GUID" />
+ <UpdateColumn name="LIQUID_TYPE_GUID" />
+ <UpdateColumn name="CARTRIDGE_TYPE_GUID" />
+ <UpdateColumn name="MID_TANK_TYPE_GUID" />
+ <UpdateColumn name="IDS_PACK_FORMULA_GUID" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PACK_INDEX" />
+ <UpdateColumn name="IS_EMPTY" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Machine" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SERIAL_NUMBER" />
+ <Column name="NAME" />
+ <Column name="PRODUCTION_DATE" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="MACHINE_VERSION_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="ENABLE_EXTERNAL_BRIDGE" />
+ <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+ <Column name="DEFAULT_RML_GUID" />
+ <Column name="TARGET_JOB_TYPES" />
+ <Column name="DEFAULT_COLOR_SPACE_GUID" />
+ <Column name="DEFAULT_SEGMENT_LENGTH" />
+ <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+ <Column name="SYNCHED" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="SERIAL_NUMBER" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PRODUCTION_DATE" />
+ <UpdateColumn name="ORGANIZATION_GUID" />
+ <UpdateColumn name="MACHINE_VERSION_GUID" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+ <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+ <UpdateColumn name="DEFAULT_RML_GUID" />
+ <UpdateColumn name="TARGET_JOB_TYPES" />
+ <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+ <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+ <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+ <UpdateColumn name="SYNCHED" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="SERIAL_NUMBER" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PRODUCTION_DATE" />
+ <UpdateColumn name="ORGANIZATION_GUID" />
+ <UpdateColumn name="MACHINE_VERSION_GUID" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+ <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+ <UpdateColumn name="DEFAULT_RML_GUID" />
+ <UpdateColumn name="TARGET_JOB_TYPES" />
+ <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+ <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+ <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+ <UpdateColumn name="SYNCHED" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_Organization" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CONTACT_GUID" />
+ <UpdateColumn name="ADDRESS_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CONTACT_GUID" />
+ <UpdateColumn name="ADDRESS_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ <Item name="Sync_UsersRoles" type="query" extracted="True">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="USER_GUID" />
+ <Column name="ROLE_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="USER_GUID" />
+ <UpdateColumn name="ROLE_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="USER_GUID" />
+ <UpdateColumn name="ROLE_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Item>
+ </Items>
+ <SchemaMapping>
+ <SMItem schema1="dbo" schema2="dbo" />
+ </SchemaMapping>
+ <ProjectSettings>
+ <AllSettings>
+ <ComparisonCaseSensitive>1</ComparisonCaseSensitive>
+ <CompareTrimmedStrings>False</CompareTrimmedStrings>
+ <EmptyEqualsNull>False</EmptyEqualsNull>
+ <PrecedeStringConstWithNPrefix>0</PrecedeStringConstWithNPrefix>
+ <AutoSelectKeyColumns>0</AutoSelectKeyColumns>
+ <PerformanceOptions>
+ <PerformanceOption name="Auto" value="True" />
+ </PerformanceOptions>
+ </AllSettings>
+ </ProjectSettings>
+</SqlDataExaminer> \ No newline at end of file
diff --git a/Software/DB/Tango.mdf b/Software/DB/Tango.mdf
index 74e15e095..e73085417 100644
--- a/Software/DB/Tango.mdf
+++ b/Software/DB/Tango.mdf
Binary files differ
diff --git a/Software/DB/Tango_log.ldf b/Software/DB/Tango_log.ldf
index a25e2ea26..4635dbde3 100644
--- a/Software/DB/Tango_log.ldf
+++ b/Software/DB/Tango_log.ldf
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Action.cs b/Software/Visual_Studio/Tango.SQLExaminer/Action.cs
new file mode 100644
index 000000000..5f7be7751
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Action.cs
@@ -0,0 +1,29 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class Action
+ {
+ [XmlAttribute("type")]
+ public String Type { get; set; }
+
+ [XmlAttribute("path")]
+ public String Path { get; set; }
+
+ [XmlAttribute("reportType")]
+ public String ReportType { get; set; }
+
+ [XmlAttribute("reportOn")]
+ public String ReportOn { get; set; }
+
+ public Action()
+ {
+ Type = "synchronize";
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs
new file mode 100644
index 000000000..13c58f906
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs
@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class AdditionalOption
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+
+ [XmlAttribute("value")]
+ public String Value { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Column.cs b/Software/Visual_Studio/Tango.SQLExaminer/Column.cs
new file mode 100644
index 000000000..69a3e455f
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Column.cs
@@ -0,0 +1,17 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class Column
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+ [XmlAttribute("key")]
+ public String Key { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs
new file mode 100644
index 000000000..9e2bbd613
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs
@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class ComparisonOption
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+
+ [XmlAttribute("value")]
+ public String Value { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs b/Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs
new file mode 100644
index 000000000..b2d21df88
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs
@@ -0,0 +1,30 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class DataSource
+ {
+ [XmlAttribute("id")]
+ public int ID { get; set; }
+
+ [XmlAttribute("server")]
+ public String Server { get; set; }
+
+ [XmlAttribute("database")]
+ public String DataBase { get; set; }
+
+ [XmlAttribute("winAuth")]
+ public String IntegratedSecurity { get; set; }
+
+ [XmlAttribute("login")]
+ public String UserName { get; set; }
+
+ [XmlAttribute("password")]
+ public String Password { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs
new file mode 100644
index 000000000..37d9da0d0
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs
@@ -0,0 +1,83 @@
+using System;
+using System.Collections.Generic;
+using System.IO;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ [XmlRoot("config")]
+ public class ExaminerConfiguration
+ {
+ [XmlAttribute("version")]
+ public int Version { get; set; }
+
+ [XmlAttribute("maker")]
+ public String Maker { get; set; }
+
+ public List<DataSource> DataSources { get; set; }
+
+ public List<Action> Actions { get; set; }
+
+ public Options Options { get; set; }
+
+ public Objects Objects { get; set; }
+
+ [XmlIgnore]
+ public ExaminerConfigurationType ConfigurationType { get; set; }
+
+ public ExaminerConfiguration()
+ {
+ Version = 2;
+ Maker = "Twine";
+ DataSources = new List<DataSource>();
+ Actions = new List<Action>();
+ Options = new Options();
+ Objects = new Objects();
+ }
+
+ public static ExaminerConfiguration FromFile(String filePath)
+ {
+ return FromString(File.ReadAllText(filePath));
+ }
+
+ public static ExaminerConfiguration FromString(String xml)
+ {
+ XmlSerializer f = new XmlSerializer(typeof(ExaminerConfiguration), "");
+
+ ExaminerConfiguration config = null;
+
+ using (var reader = new StringReader(xml))
+ {
+ config = f.Deserialize(reader) as ExaminerConfiguration;
+ }
+
+ return config;
+ }
+
+ public void ToFile(String filePath)
+ {
+ File.WriteAllText(filePath, ToXml());
+ }
+
+ public String ToXml()
+ {
+ XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
+ ns.Add("", "");
+
+ XmlSerializer f = new XmlSerializer(typeof(ExaminerConfiguration), "");
+
+ String result = String.Empty;
+
+ using (var st = new StringWriter())
+ {
+ f.Serialize(st, this, ns);
+ result = st.ToString();
+ }
+
+ return result;
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs
new file mode 100644
index 000000000..76c28c302
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs
@@ -0,0 +1,89 @@
+using System;
+using System.Collections.Generic;
+using System.IO;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using Tango.Core.Helpers;
+
+namespace Tango.SQLExaminer
+{
+ public class ExaminerConfigurationBuilder
+ {
+ private ExaminerConfiguration _config;
+ private static String _sql_examiner_folder;
+ private static String _sql_examiner_config_folder;
+
+ static ExaminerConfigurationBuilder()
+ {
+ _sql_examiner_folder = Path.Combine(AssemblyHelper.GetCurrentAssemblyFolder(), "SQLExaminer");
+ _sql_examiner_config_folder = Path.Combine(_sql_examiner_folder, "Configurations");
+ }
+
+ private String GetConfigurationFilePath(ExaminerConfigurationType type)
+ {
+ return Path.Combine(_sql_examiner_config_folder, type.ToString() + ".xml");
+ }
+
+ public ExaminerConfigurationBuilder(ExaminerConfigurationType type)
+ {
+ _config = ExaminerConfiguration.FromFile(GetConfigurationFilePath(type));
+ _config.ConfigurationType = type;
+ _config.DataSources.Clear();
+ }
+
+ public ExaminerConfigurationBuilder SetSourceServer(String address, String userName, String password)
+ {
+ _config.DataSources.Add(new DataSource()
+ {
+ ID = 1,
+ DataBase = "Tango",
+ Server = address,
+ UserName = userName,
+ Password = password,
+ });
+
+ return this;
+ }
+
+ public ExaminerConfigurationBuilder SetTargetServer(String address)
+ {
+ _config.DataSources.Add(new DataSource()
+ {
+ ID = 2,
+ DataBase = "Tango",
+ Server = address,
+ IntegratedSecurity = "True",
+ });
+
+ return this;
+ }
+
+ public ExaminerConfigurationBuilder SetBackupFile(String path)
+ {
+ var backup_action = _config.Actions.SingleOrDefault(x => x.ReportType == "backup");
+ if (backup_action != null)
+ {
+ backup_action.Path = path;
+ }
+
+ return this;
+ }
+
+ public ExaminerConfigurationBuilder SetReportFile(String path)
+ {
+ var Report_action = _config.Actions.SingleOrDefault(x => x.ReportType == "report");
+ if (Report_action != null)
+ {
+ Report_action.Path = path;
+ }
+
+ return this;
+ }
+
+ public ExaminerConfiguration Build()
+ {
+ return _config;
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs
new file mode 100644
index 000000000..be88dcb1e
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs
@@ -0,0 +1,14 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.SQLExaminer
+{
+ public enum ExaminerConfigurationType
+ {
+ Schema,
+ OverrideData
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Filter.cs b/Software/Visual_Studio/Tango.SQLExaminer/Filter.cs
new file mode 100644
index 000000000..373458139
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Filter.cs
@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.SQLExaminer
+{
+ public class Filter
+ {
+ public List<IncludeItem> Include { get; set; }
+
+ public Filter()
+ {
+ Include = new List<IncludeItem>();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs b/Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs
new file mode 100644
index 000000000..6b708cc86
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs
@@ -0,0 +1,21 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class IncludeItem
+ {
+ [XmlAttribute("type")]
+ public String Type { get; set; }
+
+ [XmlAttribute("expressiontype")]
+ public String ExpressionType { get; set; }
+
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs b/Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs
new file mode 100644
index 000000000..81fd7e126
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs
@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class KeyColumn
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Object.cs b/Software/Visual_Studio/Tango.SQLExaminer/Object.cs
new file mode 100644
index 000000000..97ed81f0d
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Object.cs
@@ -0,0 +1,31 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class Object
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+
+ [XmlAttribute("type")]
+ public String Type { get; set; }
+
+ [XmlAttribute("records")]
+ public String Records { get; set; }
+
+ public List<Column> Columns { get; set; }
+
+ public List<Query> Queries { get; set; }
+
+ public Object()
+ {
+ Columns = new List<Column>();
+ Queries = new List<Query>();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs b/Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs
new file mode 100644
index 000000000..7020e0d25
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs
@@ -0,0 +1,23 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class ObjectList
+ {
+ [XmlAttribute("type")]
+ public String Type { get; set; }
+
+ [XmlElement("")]
+ public List<Object> Object { get; set; }
+
+ public ObjectList()
+ {
+ Object = new List<Object>();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Objects.cs b/Software/Visual_Studio/Tango.SQLExaminer/Objects.cs
new file mode 100644
index 000000000..8de85cdab
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Objects.cs
@@ -0,0 +1,24 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.SQLExaminer
+{
+ public class Objects
+ {
+ public SchemaMapping SchemaMapping { get; set; }
+
+ public ObjectList ObjectList { get; set; }
+
+ public Filter Filter { get; set; }
+
+ public Objects()
+ {
+ SchemaMapping = new SchemaMapping();
+ ObjectList = new ObjectList();
+ Filter = new Filter();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Options.cs b/Software/Visual_Studio/Tango.SQLExaminer/Options.cs
new file mode 100644
index 000000000..80e9f5b1e
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Options.cs
@@ -0,0 +1,27 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.SQLExaminer
+{
+ public class Options
+ {
+ public List<ComparisonOption> ComparisonOptions { get; set; }
+
+ public List<PerformanceOption> PerformanceOptions { get; set; }
+
+ public List<SyncOption> SyncOptions { get; set; }
+
+ public List<AdditionalOption> AdditionalOptions { get; set; }
+
+ public Options()
+ {
+ ComparisonOptions = new List<ComparisonOption>();
+ PerformanceOptions = new List<PerformanceOption>();
+ SyncOptions = new List<SyncOption>();
+ AdditionalOptions = new List<AdditionalOption>();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs
new file mode 100644
index 000000000..c27c1fba8
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs
@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class PerformanceOption
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+
+ [XmlAttribute("value")]
+ public String Value { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs b/Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs
new file mode 100644
index 000000000..490a21bee
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs
@@ -0,0 +1,6 @@
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+[assembly: AssemblyTitle("Tango - SQL Examiner synchronization library")]
+[assembly: AssemblyVersion("1.0.0.0")]
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Query.cs b/Software/Visual_Studio/Tango.SQLExaminer/Query.cs
new file mode 100644
index 000000000..c890c3edf
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Query.cs
@@ -0,0 +1,25 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class Query
+ {
+ [XmlAttribute("id")]
+ public String ID { get; set; }
+
+ public XmlCDataSection Text { get; set; }
+
+ public List<Table> UpdateTables { get; set; }
+
+ public Query()
+ {
+ UpdateTables = new List<Table>();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs b/Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs
new file mode 100644
index 000000000..0d981bf57
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs
@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class SMItem
+ {
+ [XmlAttribute("schema1")]
+ public String Schema1 { get; set; }
+
+ [XmlAttribute("schema2")]
+ public String Schema2 { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml
new file mode 100644
index 000000000..f6f21dd98
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml
@@ -0,0 +1,722 @@
+<?xml version="1.0" encoding="utf-16"?>
+<config version="2" maker="SQL Data Examiner">
+ <DataSources>
+ <DataSource id="1" server="localhost\SQLEXPRESS" database="Tango" login="Synchronizer" password="Aa123456" />
+ <DataSource id="2" server="twine.local\SQLTWINE" database="Tango" winAuth="True" />
+ </DataSources>
+ <Actions>
+ <Action type="backup" path="C:\Program Files\Microsoft SQL Server\MSSQL14.SQLTWINE\MSSQL\Backup\%DB_db_%YYYY%MM%DD%HH%mm.bak" />
+ <Action type="synchronize" />
+ <Action type="report" path="C:\Users\Roy\Documents\%DB1_%DB2_%YYYY%MM%DD.htm" reportOn="Different, Same, OnlyInDb1, OnlyInDb2" />
+ </Actions>
+ <Options>
+ <ComparisonOptions>
+ <ComparisonOption name="CompareTrimmedStrings" value="False" />
+ <ComparisonOption name="EmptyEqualsNull" value="False" />
+ <ComparisonOption name="ComparisonCaseSensitive" value="CaseSensitive" />
+ <ComparisonOption name="AutoSelectKeyColumns" value="None" />
+ </ComparisonOptions>
+ <PerformanceOptions>
+ <PerformanceOption name="Auto" value="True" />
+ </PerformanceOptions>
+ <SyncOptions>
+ <SyncOption name="SynchronizeIdentity" value="True" />
+ <SyncOption name="UseTransaction" value="True" />
+ <SyncOption name="DoNotStopOnErrors" value="False" />
+ <SyncOption name="DisableTriggers" value="True" />
+ <SyncOption name="DisableUniques" value="True" />
+ <SyncOption name="DisableForeignKeys" value="True" />
+ <SyncOption name="SetAnsiWarningsOff" value="False" />
+ <SyncOption name="SqlBatchMode" value="True" />
+ <SyncOption name="SqlBatchSize" value="1MB" />
+ <SyncOption name="PrecedeStringConstWithNPrefix" value="Always" />
+ </SyncOptions>
+ <AdditionalOptions>
+ <AdditionalOption name="Nolog" value="True" />
+ </AdditionalOptions>
+ </Options>
+ <Objects>
+ <SchemaMapping>
+ <SMItem schema1="dbo" schema2="dbo" />
+ </SchemaMapping>
+ <ObjectList type="include">
+ <Object name="dbo.ACTION_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.APPLICATION_OS_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.APPLICATION_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.CARTRIDGE_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.CATS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="MACHINE_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="DATA" />
+ </Columns>
+ </Object>
+ <Object name="dbo.CCTS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="FORWARD_FILE_NAME" />
+ <Column name="INVERSE_FILE_NAME" />
+ <Column name="FORWARD_DATA" />
+ <Column name="INVERSE_DATA" />
+ <Column name="VERSION" />
+ <Column name="RML_GUID" />
+ </Columns>
+ </Object>
+ <Object name="dbo.COLOR_CATALOGS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="COLOR_SPACE_GUID" />
+ <Column name="COLOR_CODE" />
+ <Column name="NAME" />
+ <Column name="COLOR_GROUP" />
+ <Column name="CYAN" />
+ <Column name="MAGENTA" />
+ <Column name="YELLOW" />
+ <Column name="BLACK" />
+ <Column name="RED" />
+ <Column name="GREEN" />
+ <Column name="BLUE" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ <Column name="V0" />
+ <Column name="V1" />
+ <Column name="V2" />
+ <Column name="V3" />
+ <Column name="V4" />
+ <Column name="V5" />
+ <Column name="V6" />
+ <Column name="V7" />
+ </Columns>
+ </Object>
+ <Object name="dbo.COLOR_SPACES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.DISPENSER_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="NL_PER_PULSE" />
+ <Column name="CAPACITY" />
+ </Columns>
+ </Object>
+ <Object name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.EVENT_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="EVENT_TYPES_CATEGORY_GUID" />
+ <Column name="EVENT_TYPES_GROUP_GUID" />
+ <Column name="REQUIRES_USER_INTERVENTION" />
+ <Column name="HTML_PAGE_GUID" />
+ <Column name="RESOLVABLE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.EVENT_TYPES_ACTIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="EVENT_TYPE_GUID" />
+ <Column name="ACTION_TYPE_GUID" />
+ </Columns>
+ </Object>
+ <Object name="dbo.EVENT_TYPES_CATEGORIES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.EVENT_TYPES_GROUPS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.FIBER_SHAPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.FIBER_SYNTHS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_DANCER_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_DANCERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_DANCER_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="GRADUAL" />
+ <Column name="K" />
+ <Column name="X" />
+ <Column name="PULSE_PER_MM_SPRING" />
+ <Column name="MAXIMAL_MOVEMENT_MM" />
+ <Column name="ZERO_POINT" />
+ <Column name="RESOLUTION_BITS" />
+ <Column name="ARM_LENGTH" />
+ <Column name="ASSEMBLY_DIRECTION_RIGHT" />
+ <Column name="ACCELERATE_ON_TENSION_RAISE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_MOTOR_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="SUPPORTS_HOMING" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_MOTORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_MOTOR_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="MIN_FREQUENCY" />
+ <Column name="MAX_FREQUENCY" />
+ <Column name="SET_MICRO_STEP" />
+ <Column name="MICRO_STEP" />
+ <Column name="MAX_CHANGE_SLOPE" />
+ <Column name="HIGH_LENGTH_MICRO_SECOND" />
+ <Column name="SPEED_MASTER" />
+ <Column name="PULSE_PER_ROUND" />
+ <Column name="PULLEY_RADIUS" />
+ <Column name="CONFIG_WORD" />
+ <Column name="DIRECTION_THREAD_WIZE" />
+ <Column name="KVAL_HOLD" />
+ <Column name="KVAL_RUN" />
+ <Column name="KVAL_ACC" />
+ <Column name="KVAL_DEC" />
+ <Column name="OVER_CURRENT_THRESHOLD" />
+ <Column name="STALL_THRESHOLD" />
+ <Column name="THERMAL_COMPENSATION_FACTOR" />
+ <Column name="LOW_SPEED_OPTIMIZATION" />
+ <Column name="ST_SLP" />
+ <Column name="INT_SPD" />
+ <Column name="FN_SLP_ACC" />
+ <Column name="FN_SLP_DEC" />
+ <Column name="FS_SPD" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_PID_CONTROLS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" />
+ <Column name="OUTPUT_PROPORTIONAL_BAND" />
+ <Column name="INTEGRAL_TIME" />
+ <Column name="DERIVATIVE_TIME" />
+ <Column name="SENSOR_CORRECTION_ADJUSTMENT" />
+ <Column name="SENSOR_MIN_VALUE" />
+ <Column name="SENSOR_MAX_VALUE" />
+ <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" />
+ <Column name="SET_POINT_CONTROL_OUTPUT_RATE" />
+ <Column name="CONTROL_OUTPUT_TYPE" />
+ <Column name="SSR_CONTROL_OUTPUT_TYPE" />
+ <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" />
+ <Column name="PROCESS_VARIABLE_SAMPLING_RATE" />
+ <Column name="PV_INPUT_FILTER_FACTOR_MODE" />
+ <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
+ <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
+ <Column name="PROPORTIONAL_GAIN" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_SPEED_SENSORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="RESOLUTION_BITS" />
+ <Column name="PERIMETER" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_WINDER_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HARDWARE_WINDERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="HARDWARE_WINDER_TYPE_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ <Column name="MILLIMETER_PER_ROTATION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.HTML_PAGES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="HTML" />
+ </Columns>
+ </Object>
+ <Object name="dbo.IDS_PACK_FORMULAS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="AUTO_CALCULATED" />
+ </Columns>
+ </Object>
+ <Object name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.LIQUID_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="VERSION" />
+ <Column name="COLOR" />
+ </Columns>
+ </Object>
+ <Object name="dbo.LIQUID_TYPES_RMLS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="RML_GUID" />
+ <Column name="MAX_NL_PER_CM" />
+ </Columns>
+ </Object>
+ <Object name="dbo.MACHINE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="VERSION" />
+ <Column name="NAME" />
+ <Column name="DEFAULT_CONFIGURATION_GUID" />
+ </Columns>
+ </Object>
+ <Object name="dbo.MEDIA_COLORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="L" />
+ <Column name="A" />
+ <Column name="B" />
+ </Columns>
+ </Object>
+ <Object name="dbo.MEDIA_CONDITIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.MEDIA_MATERIALS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.MEDIA_PURPOSES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CODE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.MID_TANK_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="LITER_CAPACITY" />
+ </Columns>
+ </Object>
+ <Object name="dbo.PERMISSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.PROCESS_PARAMETERS_TABLES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="DYEING_SPEED" />
+ <Column name="MIN_INK_UPTAKE" />
+ <Column name="FEEDER_TENSION" />
+ <Column name="PULLER_TENSION" />
+ <Column name="WINDER_TENSION" />
+ <Column name="MIXER_TEMP" />
+ <Column name="HEAD_ZONE1_TEMP" />
+ <Column name="HEAD_ZONE2_TEMP" />
+ <Column name="HEAD_ZONE3_TEMP" />
+ <Column name="HEAD_ZONE4_TEMP" />
+ <Column name="HEAD_ZONE5_TEMP" />
+ <Column name="HEAD_ZONE6_TEMP" />
+ <Column name="DRYER_AIR_FLOW" />
+ <Column name="DRYER_ZONE1_TEMP" />
+ <Column name="DRYER_ZONE2_TEMP" />
+ <Column name="DRYER_ZONE3_TEMP" />
+ <Column name="DRYER_BUFFER_LENGTH" />
+ <Column name="HEAD_AIR_FLOW" />
+ <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
+ <Column name="TABLE_INDEX" />
+ </Columns>
+ </Object>
+ <Object name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="RML_GUID" />
+ <Column name="NAME" />
+ <Column name="ACTIVE" />
+ <Column name="SAVE_DATE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.RMLS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="MANUFACTURER" />
+ <Column name="CODE" />
+ <Column name="MEDIA_MATERIAL_GUID" />
+ <Column name="MEDIA_COLOR_GUID" />
+ <Column name="MEDIA_PURPOSE_GUID" />
+ <Column name="MEDIA_CONDITION_GUID" />
+ <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" />
+ <Column name="FIBER_SHAPE_GUID" />
+ <Column name="FIBER_SYNTH_GUID" />
+ <Column name="FIBER_SIZE" />
+ <Column name="NUMBER_OF_FIBERS" />
+ <Column name="PLIES_PER_FIBER" />
+ <Column name="PLIES_PER_THREAD" />
+ <Column name="TWISTED" />
+ <Column name="AIR_ENTANGLEMENT" />
+ <Column name="LUBRICANT" />
+ <Column name="TENSILE_STRENGTH" />
+ <Column name="ELONGATION_AT_BREAK_PERCENTAGE" />
+ <Column name="ESTIMATED_THREAD_DIAMETER" />
+ </Columns>
+ </Object>
+ <Object name="dbo.ROLES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.ROLES_PERMISSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="ROLE_GUID" />
+ <Column name="PERMISSION_GUID" />
+ </Columns>
+ </Object>
+ <Object name="dbo.SPOOL_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="LENGTH" />
+ <Column name="WEIGHT" />
+ <Column name="DIAMETER" />
+ <Column name="START_OFFSET_PULSES" />
+ <Column name="BACKING_RATE" />
+ <Column name="SEGMENT_OFFSET_PULSES" />
+ <Column name="BOTTOM_BACKING_RATE" />
+ <Column name="ROTATIONS_PER_PASSAGE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.SYNC_CONFIGURATIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="ID" key="true" />
+ <Column name="TABLE_NAME" />
+ <Column name="SYNC_TYPE" />
+ </Columns>
+ </Object>
+ <Object name="dbo.TECH_CONTROLLERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ <Column name="UNITS" />
+ </Columns>
+ </Object>
+ <Object name="dbo.TECH_DISPENSERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.TECH_IOS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="PORT" />
+ <Column name="TYPE" />
+ <Column name="DESIGNATOR" />
+ <Column name="ASM" />
+ <Column name="INTERFACE_NAME" />
+ <Column name="SENSOR" />
+ <Column name="INIT_VALUE" />
+ <Column name="AVERAGING" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ </Columns>
+ </Object>
+ <Object name="dbo.TECH_MONITORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ <Column name="MIN" />
+ <Column name="MAX" />
+ <Column name="UNITS" />
+ <Column name="POINTS_PER_FRAME" />
+ <Column name="MULTI_CHANNEL" />
+ <Column name="CHANNEL_COUNT" />
+ </Columns>
+ </Object>
+ <Object name="dbo.TECH_VALVES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ <Object name="dbo.WINDING_METHODS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CODE" />
+ <Column name="NAME" />
+ <Column name="DESCRIPTION" />
+ </Columns>
+ </Object>
+ </ObjectList>
+ </Objects>
+</config>
+
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml
new file mode 100644
index 000000000..99f726462
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml
@@ -0,0 +1,560 @@
+<?xml version="1.0" encoding="utf-16"?>
+<config version="2" maker="SQL Data Examiner">
+ <DataSources>
+ <DataSource id="1" server="localhost\SQLEXPRESS" database="Tango" login="Synchronizer" password="Aa123456" />
+ <DataSource id="2" server="twine.local\SQLTWINE" database="Tango" winAuth="True" />
+ </DataSources>
+ <Actions>
+ <Action type="synchronize" />
+ <Action type="report" path="C:\Users\Roy\Documents\%DB1_%DB2_%YYYY%MM%DD.htm" reportOn="Different, Same, OnlyInDb1, OnlyInDb2" />
+ </Actions>
+ <Options>
+ <ComparisonOptions>
+ <ComparisonOption name="CompareTrimmedStrings" value="False" />
+ <ComparisonOption name="EmptyEqualsNull" value="False" />
+ <ComparisonOption name="ComparisonCaseSensitive" value="CaseSensitive" />
+ <ComparisonOption name="AutoSelectKeyColumns" value="None" />
+ </ComparisonOptions>
+ <PerformanceOptions>
+ <PerformanceOption name="Auto" value="True" />
+ </PerformanceOptions>
+ <SyncOptions>
+ <SyncOption name="SynchronizeIdentity" value="True" />
+ <SyncOption name="UseTransaction" value="True" />
+ <SyncOption name="DoNotStopOnErrors" value="False" />
+ <SyncOption name="DisableTriggers" value="True" />
+ <SyncOption name="DisableUniques" value="True" />
+ <SyncOption name="DisableForeignKeys" value="True" />
+ <SyncOption name="SetAnsiWarningsOff" value="False" />
+ <SyncOption name="SqlBatchMode" value="True" />
+ <SyncOption name="SqlBatchSize" value="1MB" />
+ <SyncOption name="PrecedeStringConstWithNPrefix" value="Always" />
+ </SyncOptions>
+ <AdditionalOptions>
+ <AdditionalOption name="Nolog" value="True" />
+ </AdditionalOptions>
+ </Options>
+ <Objects>
+ <SchemaMapping>
+ <SMItem schema1="dbo" schema2="dbo" />
+ </SchemaMapping>
+ <ObjectList type="include">
+ <Object name="Sync_Addresses" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="ADDRESS_STRING" />
+ <Column name="LOCALITY" />
+ <Column name="COUNTRY" />
+ <Column name="CITY" />
+ <Column name="STATE" />
+ <Column name="COUNTRY_CODE" />
+ <Column name="POSTAL_CODE" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text>
+ <![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="ADDRESS_STRING" />
+ <UpdateColumn name="LOCALITY" />
+ <UpdateColumn name="COUNTRY" />
+ <UpdateColumn name="CITY" />
+ <UpdateColumn name="STATE" />
+ <UpdateColumn name="COUNTRY_CODE" />
+ <UpdateColumn name="POSTAL_CODE" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text>
+ <![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="ADDRESS_STRING" />
+ <UpdateColumn name="LOCALITY" />
+ <UpdateColumn name="COUNTRY" />
+ <UpdateColumn name="CITY" />
+ <UpdateColumn name="STATE" />
+ <UpdateColumn name="COUNTRY_CODE" />
+ <UpdateColumn name="POSTAL_CODE" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ <Object name="Sync_Configuration" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CREATION_DATE" />
+ <Column name="APPLICATION_VERSION_GUID" />
+ <Column name="APPLICATION_OS_VERSION_GUID" />
+ <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <Column name="HARDWARE_VERSION_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text>
+ <![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CREATION_DATE" />
+ <UpdateColumn name="APPLICATION_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <UpdateColumn name="HARDWARE_VERSION_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text>
+ <![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CREATION_DATE" />
+ <UpdateColumn name="APPLICATION_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+ <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+ <UpdateColumn name="HARDWARE_VERSION_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ <Object name="Sync_Contacts" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="FIRST_NAME" />
+ <Column name="LAST_NAME" />
+ <Column name="FULL_NAME" />
+ <Column name="EMAIL" />
+ <Column name="PHONE_NUMBER" />
+ <Column name="FAX" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text>
+ <![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="FIRST_NAME" />
+ <UpdateColumn name="LAST_NAME" />
+ <UpdateColumn name="FULL_NAME" />
+ <UpdateColumn name="EMAIL" />
+ <UpdateColumn name="PHONE_NUMBER" />
+ <UpdateColumn name="FAX" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text>
+ <![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="FIRST_NAME" />
+ <UpdateColumn name="LAST_NAME" />
+ <UpdateColumn name="FULL_NAME" />
+ <UpdateColumn name="EMAIL" />
+ <UpdateColumn name="PHONE_NUMBER" />
+ <UpdateColumn name="FAX" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ <Object name="Sync_IdsPacks" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="DISPENSER_TYPE_GUID" />
+ <Column name="LIQUID_TYPE_GUID" />
+ <Column name="CARTRIDGE_TYPE_GUID" />
+ <Column name="MID_TANK_TYPE_GUID" />
+ <Column name="IDS_PACK_FORMULA_GUID" />
+ <Column name="NAME" />
+ <Column name="PACK_INDEX" />
+ <Column name="IS_EMPTY" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text>
+ <![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES
+ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+ INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]>
+ </Text>
+ </Query>
+ <Query id="2">
+ <Text>
+ <![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES
+ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+ INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="DISPENSER_TYPE_GUID" />
+ <UpdateColumn name="LIQUID_TYPE_GUID" />
+ <UpdateColumn name="CARTRIDGE_TYPE_GUID" />
+ <UpdateColumn name="MID_TANK_TYPE_GUID" />
+ <UpdateColumn name="IDS_PACK_FORMULA_GUID" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PACK_INDEX" />
+ <UpdateColumn name="IS_EMPTY" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ <Object name="Sync_Machine" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="SERIAL_NUMBER" />
+ <Column name="NAME" />
+ <Column name="PRODUCTION_DATE" />
+ <Column name="ORGANIZATION_GUID" />
+ <Column name="MACHINE_VERSION_GUID" />
+ <Column name="CONFIGURATION_GUID" />
+ <Column name="ENABLE_EXTERNAL_BRIDGE" />
+ <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+ <Column name="DEFAULT_RML_GUID" />
+ <Column name="TARGET_JOB_TYPES" />
+ <Column name="DEFAULT_COLOR_SPACE_GUID" />
+ <Column name="DEFAULT_SEGMENT_LENGTH" />
+ <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+ <Column name="SYNCHED" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="SERIAL_NUMBER" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PRODUCTION_DATE" />
+ <UpdateColumn name="ORGANIZATION_GUID" />
+ <UpdateColumn name="MACHINE_VERSION_GUID" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+ <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+ <UpdateColumn name="DEFAULT_RML_GUID" />
+ <UpdateColumn name="TARGET_JOB_TYPES" />
+ <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+ <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+ <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+ <UpdateColumn name="SYNCHED" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+ <UpdateTables>
+ <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="SERIAL_NUMBER" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="PRODUCTION_DATE" />
+ <UpdateColumn name="ORGANIZATION_GUID" />
+ <UpdateColumn name="MACHINE_VERSION_GUID" />
+ <UpdateColumn name="CONFIGURATION_GUID" />
+ <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+ <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+ <UpdateColumn name="DEFAULT_RML_GUID" />
+ <UpdateColumn name="TARGET_JOB_TYPES" />
+ <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+ <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+ <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+ <UpdateColumn name="SYNCHED" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ <Object name="Sync_Organization" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="NAME" />
+ <Column name="CONTACT_GUID" />
+ <Column name="ADDRESS_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text>
+ <![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CONTACT_GUID" />
+ <UpdateColumn name="ADDRESS_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text>
+ <![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="NAME" />
+ <UpdateColumn name="CONTACT_GUID" />
+ <UpdateColumn name="ADDRESS_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ <Object name="Sync_UsersRoles" type="query">
+ <Columns>
+ <Column name="GUID" key="true" />
+ <Column name="ID" />
+ <Column name="LAST_UPDATED" />
+ <Column name="DELETED" />
+ <Column name="USER_GUID" />
+ <Column name="ROLE_GUID" />
+ </Columns>
+ <Queries>
+ <Query id="1">
+ <Text>
+ <![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="USER_GUID" />
+ <UpdateColumn name="ROLE_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ <Query id="2">
+ <Text>
+ <![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]>
+ </Text>
+ <UpdateTables>
+ <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+ <KeyColumns>
+ <KeyColumn name="GUID" />
+ </KeyColumns>
+ <UpdateColumns>
+ <UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
+ <UpdateColumn name="LAST_UPDATED" />
+ <UpdateColumn name="DELETED" />
+ <UpdateColumn name="USER_GUID" />
+ <UpdateColumn name="ROLE_GUID" />
+ </UpdateColumns>
+ </Table>
+ </UpdateTables>
+ </Query>
+ </Queries>
+ </Object>
+ </ObjectList>
+ </Objects>
+</config>
+
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xml b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xml
new file mode 100644
index 000000000..8aab9ee1b
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xml
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dll
new file mode 100644
index 000000000..0a7ae1c77
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic
new file mode 100644
index 000000000..377894bba
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic
@@ -0,0 +1 @@
+5lpcKnrNcQo4qolt46ab+yKW8NAq5WtFuPbvjdTl2SLX3qb8f6YTZpaZwa93aV+aBJUaf+HQrBauC/Fd1eiq9NquvvJpGiu94E5ZO5UrE12/fv8BiXG62PUI2gRD7UAcAw1BhHkeRsQ79kqyUaVJNTl2Cy3Sb9Xy6GKVaYWHLAnT0U/Nh1kiOXWJsiSwTFeKmiij9QSwd2zDFeQT1gyqZPKu/+JqADZckY5WiKm8XFz94iMBCpMmocccW2yc+wxDVWLpX3ExtodavcUbaB5paRwjQgUf/u0x5zi+i0xtasjrcLC5kv7dYdJTRuGTqg2Jop1PQEML62wN8jvrKKShrGlm/VpzfODBOrF8SYYqVuUJMonofAUrmmiFNTIuZdhCQT6ZPzNXDwKLVr7nkAqFiUot41jozp16brPaSBuiw6kaoT6NKI5HpuW7ECvIRv8dnraC1nf2C52wirCo9w9+LE3jF10gBZ2DLWR6LMGbtYO7+KBglC4CVeCy4dqiS4kC5JJ/nckOvkqKSrZO+Q/70iz6F8cCshKKR6Ni+uKCQGSs+vbHcukJXdQxMy3CvwBF0mwqNXrByuj5XBAd67ShcoPtSHJy0MhonxDnNyNptsbT3FBqGGV1b0bg02kDrRqpSrme6d+sL4yrJbtaTrpC0yT+7cgLk/YDDGDmIQCParywPh75C7NOAj4ZpcCLujDJI86U9O+j3m5u/BJ6yZobmcBEsw2qvqjqK9/09F1qb+f9w2NvXxugsKwk7Uf/ji0TSImp2OvDourEbq+XxOhBZg== \ No newline at end of file
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dll
new file mode 100644
index 000000000..c75112cb3
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dll
new file mode 100644
index 000000000..e6841fda1
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dll
new file mode 100644
index 000000000..c0c0b941f
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dll
new file mode 100644
index 000000000..9a4bc8e42
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dll
new file mode 100644
index 000000000..2c314b5a6
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dll
new file mode 100644
index 000000000..a7dbc04ac
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dll
new file mode 100644
index 000000000..37dfba5bc
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dll
new file mode 100644
index 000000000..bbf9edc29
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dll
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exe b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exe
new file mode 100644
index 000000000..5399a70b9
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exe
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exe b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exe
new file mode 100644
index 000000000..b1671b397
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exe
Binary files differ
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs b/Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs
new file mode 100644
index 000000000..b76f192f9
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.SQLExaminer
+{
+ public class SchemaMapping : List<SMItem>
+ {
+
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs
new file mode 100644
index 000000000..5b2b053f0
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs
@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class SyncOption
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+
+ [XmlAttribute("value")]
+ public String Value { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Table.cs b/Software/Visual_Studio/Tango.SQLExaminer/Table.cs
new file mode 100644
index 000000000..e09792b0b
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Table.cs
@@ -0,0 +1,37 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class Table
+ {
+ [XmlAttribute("schema")]
+ public String Schema { get; set; }
+
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+
+ [XmlAttribute("allowDelete")]
+ public String AllowDelete { get; set; }
+
+ [XmlAttribute("allowInsert")]
+ public String AllowInsert { get; set; }
+
+ [XmlAttribute("allowUpdate")]
+ public String AllowUpdate { get; set; }
+
+ public List<KeyColumn> KeyColumns { get; set; }
+
+ public List<UpdateColumn> UpdateColumns { get; set; }
+
+ public Table()
+ {
+ KeyColumns = new List<KeyColumn>();
+ UpdateColumns = new List<UpdateColumn>();
+ }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj b/Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj
new file mode 100644
index 000000000..4858d8eaa
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj
@@ -0,0 +1,125 @@
+<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+ <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
+ <PropertyGroup>
+ <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+ <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+ <ProjectGuid>{E1E66ED9-597D-45FA-8048-DE90A6930484}</ProjectGuid>
+ <OutputType>Library</OutputType>
+ <AppDesignerFolder>Properties</AppDesignerFolder>
+ <RootNamespace>Tango.SQLExaminer</RootNamespace>
+ <AssemblyName>Tango.SQLExaminer</AssemblyName>
+ <TargetFrameworkVersion>v4.6</TargetFrameworkVersion>
+ <FileAlignment>512</FileAlignment>
+ </PropertyGroup>
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+ <DebugSymbols>true</DebugSymbols>
+ <DebugType>full</DebugType>
+ <Optimize>false</Optimize>
+ <OutputPath>..\Build\Debug\</OutputPath>
+ <DefineConstants>DEBUG;TRACE</DefineConstants>
+ <ErrorReport>prompt</ErrorReport>
+ <WarningLevel>4</WarningLevel>
+ </PropertyGroup>
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+ <DebugType>pdbonly</DebugType>
+ <Optimize>true</Optimize>
+ <OutputPath>..\Build\Release\</OutputPath>
+ <DefineConstants>TRACE</DefineConstants>
+ <ErrorReport>prompt</ErrorReport>
+ <WarningLevel>4</WarningLevel>
+ </PropertyGroup>
+ <ItemGroup>
+ <Reference Include="System" />
+ <Reference Include="System.Core" />
+ <Reference Include="System.Xml.Linq" />
+ <Reference Include="System.Data.DataSetExtensions" />
+ <Reference Include="Microsoft.CSharp" />
+ <Reference Include="System.Data" />
+ <Reference Include="System.Net.Http" />
+ <Reference Include="System.Xml" />
+ </ItemGroup>
+ <ItemGroup>
+ <Compile Include="..\Versioning\GlobalVersionInfo.cs">
+ <Link>GlobalVersionInfo.cs</Link>
+ </Compile>
+ <Compile Include="Action.cs" />
+ <Compile Include="AdditionalOption.cs" />
+ <Compile Include="Column.cs" />
+ <Compile Include="ComparisonOption.cs" />
+ <Compile Include="DataSource.cs" />
+ <Compile Include="ExaminerConfiguration.cs" />
+ <Compile Include="ExaminerConfigurationBuilder.cs" />
+ <Compile Include="ExaminerConfigurationType.cs" />
+ <Compile Include="Filter.cs" />
+ <Compile Include="IncludeItem.cs" />
+ <Compile Include="KeyColumn.cs" />
+ <Compile Include="Object.cs" />
+ <Compile Include="ObjectList.cs" />
+ <Compile Include="Objects.cs" />
+ <Compile Include="Options.cs" />
+ <Compile Include="PerformanceOption.cs" />
+ <Compile Include="Properties\AssemblyInfo.cs" />
+ <Compile Include="Query.cs" />
+ <Compile Include="SchemaMapping.cs" />
+ <Compile Include="SMItem.cs" />
+ <Compile Include="SyncOption.cs" />
+ <Compile Include="Table.cs" />
+ <Compile Include="UpdateColumn.cs" />
+ </ItemGroup>
+ <ItemGroup>
+ <Content Include="SQLExaminer\Configurations\OverrideData.xml">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\Configurations\ProvisionMachine.xml" />
+ <Content Include="SQLExaminer\Configurations\Schema.xml">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\Interop.MSDASC.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.Binary.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.CodeView.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.CommonTypes.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.CommonUI.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.SCBaseProvider.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.SQLDataExaminer.Engine.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.SQLExaminer.Engine.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SA.Utils.ErrorReporter.dll">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SQLDECmd.exe">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ <Content Include="SQLExaminer\SQLECmd.exe">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ </ItemGroup>
+ <ItemGroup>
+ <Content Include="SQLExaminer\License.lic">
+ <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+ </Content>
+ </ItemGroup>
+ <ItemGroup />
+ <ItemGroup>
+ <ProjectReference Include="..\Tango.Core\Tango.Core.csproj">
+ <Project>{a34ee0f0-649d-41c8-8489-b6f1cc6924ee}</Project>
+ <Name>Tango.Core</Name>
+ </ProjectReference>
+ </ItemGroup>
+ <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
+</Project> \ No newline at end of file
diff --git a/Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs b/Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs
new file mode 100644
index 000000000..cfac5d1bc
--- /dev/null
+++ b/Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs
@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using System.Xml.Serialization;
+
+namespace Tango.SQLExaminer
+{
+ public class UpdateColumn
+ {
+ [XmlAttribute("name")]
+ public String Name { get; set; }
+ }
+}
diff --git a/Software/Visual_Studio/Tango.sln b/Software/Visual_Studio/Tango.sln
index 65b1ca8e8..ee189e840 100644
--- a/Software/Visual_Studio/Tango.sln
+++ b/Software/Visual_Studio/Tango.sln
@@ -212,6 +212,8 @@ Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.PPC.MachineSettings",
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.CSV", "Tango.CSV\Tango.CSV.csproj", "{58E8825F-0C96-449C-B320-1E82B0AA876B}"
EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.SQLExaminer", "Tango.SQLExaminer\Tango.SQLExaminer.csproj", "{E1E66ED9-597D-45FA-8048-DE90A6930484}"
+EndProject
Global
GlobalSection(SolutionConfigurationPlatforms) = preSolution
AppVeyor|Any CPU = AppVeyor|Any CPU
@@ -3691,6 +3693,46 @@ Global
{58E8825F-0C96-449C-B320-1E82B0AA876B}.Release|x64.Build.0 = Release|x64
{58E8825F-0C96-449C-B320-1E82B0AA876B}.Release|x86.ActiveCfg = Release|x86
{58E8825F-0C96-449C-B320-1E82B0AA876B}.Release|x86.Build.0 = Release|x86
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|Any CPU.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|Any CPU.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM64.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM64.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x64.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x64.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x86.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x86.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|Any CPU.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM64.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM64.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x64.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x64.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x86.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x86.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|Any CPU.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|Any CPU.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM64.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM64.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x64.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x64.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x86.ActiveCfg = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x86.Build.0 = Debug|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|Any CPU.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|Any CPU.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM64.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM64.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x64.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x64.Build.0 = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x86.ActiveCfg = Release|Any CPU
+ {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x86.Build.0 = Release|Any CPU
EndGlobalSection
GlobalSection(SolutionProperties) = preSolution
HideSolutionNode = FALSE