Java,Jsp,模式及框架
Web技术
Web服务器
浏览器相关
SQL语言
数据库
开发环境
软件开发及管理
网站SEO
短信及邮件服务
网页设计
电脑、硬件及网络
协同管理平台问题
电子商务
前沿技术及趋势
  当前位置:首页 - 知识积累 - 协同管理平台问题
kokooa空间迁徙到jysfj的数据操作
时间:2009年10月25日 

insert into [05oa-jysfj].dbo.xloa_user
SELECT [USER_LOGIN_ID], [CURRENT_PASSWORD], [ENABLED], [DATE], [USER_ID], [USER_NAME], [DEPT_ID], [ORDER_NO], [ICON], [SEX], [NICK_NAME], [BIRTHDAY], [MATE],

[CHILD], [MOBILE_NO], [EMAIL], [MSN], [QQ], [DEPT_NAME], [POST], [DEPT_ADDR], [DEPT_POST_NO], [DEPT_TEL_NO], [DEPT_FAX_NO], [HOME_ADDR], [HOME_POST_NO],

[HOME_TEL_NO], [HOME_FAX_NO], [HOME_MOBILE_NO], [COMMENT], [NAMESPACE], [ATTACHS], [ID_CARD_NUM] FROM [kokooa].dbo.xloa_user where namespace='sihu'


insert into [05oa-jysfj].dbo.xloa_user_dept
SELECT [USER_ID], [DEPT_ID], [ORDER_NO], [NAMESPACE], [ATTACHS] FROM [kokooa].dbo.xloa_user_dept where namespace='sihu'

insert into [05oa-jysfj].dbo.department
SELECT [DEPT_ID], [DEPT_NAME], [PARENT_ID], [DATE], [FULL_NAME], [ORDER_NO], [ICON], [CACTEGORY], [COME_FROM], [INDUSTRY], [SCALE], [PHASE], [LEVEL],

[LEVEL2], [LEVEL3], [LEVEL4], [COUNTRY], [PROVINCE], [CITY], [TEL], [FAX], [WEBSITE], [POSTCODE], [ADDRESS], [COMMENT], [NAMESPACE], [USERS_EDIT], [OWNER],

[TYPE], [USERS_VIEW], [ATTACHS] FROM [kokooa].dbo.department where namespace='sihu'

insert into [05oa-jysfj].dbo.xloa_space
SELECT [SPACE_ID], [SPACE_NAME], [USER_ID], [ENABLED], [SMS_NO], [EMAIL_ACCOUNT], [USERS_SMS], [NUM_DEPT], [NUM_USER], [NAMESPACE], [DOMAIN_NAMES], [WIDTH],

[BG], [LOGO], [ATTACHS]
FROM [kokooa].dbo.xloa_space where space_id='sihu'

......