4 -------------------+-------------------+-------------------+
5 Data | In CSQL | In TargetDB |
6 -------------------+-------------------+-------------------+
7 No. Of Records |
5 |
5 |
8 -------------------+-------------------+-------------------+
12 -------------------+-------------------+-------------------+
13 Data | In CSQL | In TargetDB |
14 -------------------+-------------------+-------------------+
15 No. Of Records |
5 |
5 |
16 -------------------+-------------------+-------------------+
18 Primary key field name is
'f4'
20 Missing Records
: Marked by
'X'
21 -------------------+-------------------+-------------------+
22 Primary Key | In CSQL | In Target DB |
23 -------------------+-------------------+-------------------+
24 No missing Records
in either of the databases |
25 -------------------+-------------------+-------------------+
29 -------------------+-------------------+-------------------+
30 Data | In CSQL | In TargetDB |
31 -------------------+-------------------+-------------------+
32 No. Of Records |
5 |
5 |
33 -------------------+-------------------+-------------------+
35 Primary key field name is
'f4'
37 Missing Records
: Marked by
'X'
38 -------------------+-------------------+-------------------+
39 Primary Key | In CSQL | In Target DB |
40 -------------------+-------------------+-------------------+
41 No missing Records
in either of the databases |
42 -------------------+-------------------+-------------------+
44 Inconsistent Records
for the same key
:
45 -------------------+-------------------+-------------------+-------------------+
46 Primary Key | Field Name | In CSQL | In Trgt DB |
47 -------------------+-------------------+-------------------+-------------------+
48 The data is consistent
in both the databases |
49 -------------------+-------------------+-------------------+-------------------+
50 updating
2 records
in csql through gateway
54 -------------------+-------------------+-------------------+
55 Data | In CSQL | In TargetDB |
56 -------------------+-------------------+-------------------+
57 No. Of Records |
5 |
5 |
58 -------------------+-------------------+-------------------+
60 Primary key field name is
'f4'
62 Missing Records
: Marked by
'X'
63 -------------------+-------------------+-------------------+
64 Primary Key | In CSQL | In Target DB |
65 -------------------+-------------------+-------------------+
66 No missing Records
in either of the databases |
67 -------------------+-------------------+-------------------+
69 Inconsistent Records
for the same key
:
70 -------------------+-------------------+-------------------+-------------------+
71 Primary Key | Field Name | In CSQL | In Trgt DB |
72 -------------------+-------------------+-------------------+-------------------+
73 The data is consistent
in both the databases |
74 -------------------+-------------------+-------------------+-------------------+
75 deleting
2 records
in csql through gateway
79 -------------------+-------------------+-------------------+
80 Data | In CSQL | In TargetDB |
81 -------------------+-------------------+-------------------+
82 No. Of Records |
3 |
3 |
83 -------------------+-------------------+-------------------+
85 Primary key field name is
'f4'
87 Missing Records
: Marked by
'X'
88 -------------------+-------------------+-------------------+
89 Primary Key | In CSQL | In Target DB |
90 -------------------+-------------------+-------------------+
91 No missing Records
in either of the databases |
92 -------------------+-------------------+-------------------+
93 updating
2 records
in mysql
97 -------------------+-------------------+-------------------+
98 Data | In CSQL | In TargetDB |
99 -------------------+-------------------+-------------------+
100 No. Of Records |
3 |
3 |
101 -------------------+-------------------+-------------------+
103 Primary key field name is
'f4'
105 Missing Records
: Marked by
'X'
106 -------------------+-------------------+-------------------+
107 Primary Key | In CSQL | In Target DB |
108 -------------------+-------------------+-------------------+
109 No missing Records
in either of the databases |
110 -------------------+-------------------+-------------------+
112 Inconsistent Records
for the same key
:
113 -------------------+-------------------+-------------------+-------------------+
114 Primary Key | Field Name | In CSQL | In Trgt DB |
115 -------------------+-------------------+-------------------+-------------------+
116 Govind | t1.f5 |
100.111000 |
150.000000 |
117 Gopal | t1.f5 |
200.222000 |
150.000000 |
118 -------------------+-------------------+-------------------+-------------------+
119 deleting
2 records
in mysql
123 -------------------+-------------------+-------------------+
124 Data | In CSQL | In TargetDB |
125 -------------------+-------------------+-------------------+
126 No. Of Records |
3 |
1 |
127 -------------------+-------------------+-------------------+
129 Primary key field name is
'f4'
131 Missing Records
: Marked by
'X'
132 -------------------+-------------------+-------------------+
133 Primary Key | In CSQL | In Target DB |
134 -------------------+-------------------+-------------------+
137 -------------------+-------------------+-------------------+