| Report Attribute | Value |
|---|---|
| Report Created | 21-Oct-2016 17:08 |
| DTM Migration Kit | 1.13.04, Unicode, x86 |
| Rules | 11 |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Export data |
| Label | EXPORT1 |
| Execution | Yes |
| Source Connection | ODBC: LocalServer//dbo/Northwind |
| Source Table | dbo.A1 |
| Export Type | SQL script |
| Source Fields | F1, F2, F3 |
| List of Tables | EDMSUSER.TSACTDEF |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Data migration |
| Execution | Yes |
| Source Connection | ODBC: LocalServer///Northwind |
| Target Connection | ODBC: LocalServer/Northwind//NorthwindOld |
| Source Table | dbo.A1 |
| Target Table | A12 |
| Records Mode | All Records |
| Table Mode | Single table |
| New Table Mode | Yes |
| Source Fields | F1, F2, F3 |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Import data |
| Execution | Yes |
| Source Connection | Microsoft Access Driver : D:\db1.mdb |
| Target Connection | ODBC: Access1/Northwind/ |
| Import Type | MS Access |
| Source Table | SQLeditor |
| Target Table | ex2 |
| Records Mode | All Records |
| Table Mode | Single table |
| New Table Mode | No, use existing |
| Source Fields | Subject, `From`, `Sender Name`, CC, `To`, Received, `Message Size`, Contents, Created, Modified, `Has Attachments`, `Normalized Subject` |
| Target Fields | Institution Id, SECTION, CATEGORY, SUBCATEGORY, ITEM, DataTypes, VALUE, SHORTCODE, SENSITIVITYLEVEL, VALUELEVEL |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Clear/Drop object |
| Label | DropPhones |
| Execution | Yes |
| Source Connection | ODBC: LocalServer///Northwind |
| Source Table | dbo.Phones2 |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Schema migration |
| Execution | Yes |
| Source Connection | ODBC: LocalServer///Northwind |
| Target Connection | ODBC: LocalServer/Northwind//NorthwindOld |
| Source Table | [user].A1 |
| Objects | Tables Defaults CheckConstraints Views Indexes Procedures Triggers PrimaryKeys ForeignKeys |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | If condition go to |
| Execution | Yes |
| Source Connection | ODBC: // |
| Target Label | EXPORT1 |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Go to |
| Execution | Yes |
| Source Connection | ODBC: // |
| Target Label | EXPORT1 |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Stop the project execution |
| Label | STOP |
| Execution | Yes |
| Source Connection | ODBC: // |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Run external |
| Execution | Yes |
| Source Connection | ODBC: // |
| Command Line | list.exe > lst.txt |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Execute SQL script |
| Execution | Yes |
| Source Connection | ODBC: LocalServer///Northwind |
| Script File | update1*.sql |
| Rule Property | Value |
|---|---|
| Status | Enabled |
| Type | Send e-mail |
| Execution | Yes |
| Source Connection | ODBC: // |
| support@dtmsoft.com | |
| Subject | Check Failed for setver1 |