广州、天津、长沙、珠海、北京数据迁移

buguid：

--'CC52AA07-AB5A-4E90-B86D-FA272D1DE371'-- 珠海
--,'F6B010E6-5C72-48E3-865F-FF354C6CF7CF'-- 广州
--,'41D7E343-94DF-4DDF-80C5-C37DE68FA7B9'-- 长沙
--,'8D3C1CCC-7D26-4218-BE40-538E3726878C'-- 天津
--,'16D94395-1EE1-4394-B805-890C7170CF06'-- 北京

客户导出：individCst_data_

SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_141 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);




SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_142 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_143 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_144 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_145 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_146 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_147 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_148 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_149 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_150 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_151
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);

View Code

跟进导出：followRecord_data_

SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_141 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_141  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_142 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_142  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_143 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_143  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_144 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_144  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_145 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_145  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_146 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_146  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_147 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_147  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_148 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_148  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_149 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_149  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_150 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_150  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_151 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_151  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

View Code

mapping

SELECT * from cst_CstGUIDMapping_0 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_1 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_2 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_3 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_4 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_5 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_6 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_7 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_8 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_9 where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_A where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_B where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_C where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_D where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_E where CstGUID in (SELECT code from 21xian);
SELECT * from cst_CstGUIDMapping_F where CstGUID in (SELECT code from 21xian);

posted @ 2016-06-07 16:21 侠之大者kamil 阅读(127) 评论(0) 编辑收藏举报

刷新页面返回顶部

侠之大者

广州、天津、长沙、珠海、北京 数据迁移

buguid：

客户导出：individCst_data_

跟进导出：followRecord_data_

公告

广州、天津、长沙、珠海、北京数据迁移