ESON墨西哥所有菜單同步昆山廠 SQL

最新推荐文章于 2019-03-09 14:52:08 发布

jaxkxu

最新推荐文章于 2019-03-09 14:52:08 发布

阅读量1.2k

点赞数

分类专栏： ESON 文章标签： insert user domain delete sql

本文链接：https://blog.youkuaiyun.com/jaxkxu/article/details/5798877

版权

ESON 专栏收录该内容

38 篇文章

订阅专栏

本文提供了一套完整的数据库同步迁移方案，通过删除目标数据库中的数据并插入源数据库的数据来实现同步。涉及的操作包括域信息、包信息、程序信息等的同步，并对特定角色和用户的权限进行了调整。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DELETE FROM DB_ESMX.BAS.DOMAIN_INFO;
INSERT INTO DB_ESMX.BAS.DOMAIN_INFO SELECT * FROM DB_ESON.BAS.DOMAIN_INFO;

DELETE FROM DB_ESMX.BAS.PACKAGE_INFO;
INSERT INTO DB_ESMX.BAS.PACKAGE_INFO SELECT * FROM DB_ESON.BAS.PACKAGE_INFO;

DELETE FROM DB_ESMX.BAS.PROGRAM_INFO;
INSERT INTO DB_ESMX.BAS.PROGRAM_INFO SELECT * FROM DB_ESON.BAS.PROGRAM_INFO;

DELETE FROM BAS.ROLE_USER WHERE ROLE_ID = 0 AND USER_ID < 10;
INSERT INTO BAS.ROLE_USER SELECT 0,USER_ID,'S',0,GETDATE() FROM BAS.USER_INFO WHERE USER_ID<10

DELETE FROM BAS.ROLE_DOMAIN WHERE ROLE_ID = 0;
INSERT INTO BAS.ROLE_DOMAIN SELECT 0,DOMAIN_NO,'S',0,GETDATE() FROM BAS.DOMAIN_INFO;

DELETE FROM BAS.ROLE_PACK WHERE ROLE_ID = 0;
INSERT INTO BAS.ROLE_PACK SELECT 0,PACK_NO,'S',0,GETDATE() FROM BAS.PACKAGE_INFO;

DELETE FROM BAS.ROLE_PROGRAM WHERE ROLE_ID = 0;
INSERT INTO BAS.ROLE_PROGRAM SELECT 0,PRO_NO,-1,'S',0,GETDATE() FROM BAS.PROGRAM_INFO;

DELETE FROM BAS.USER_PROGRAM WHERE USER_ID < 10;
INSERT INTO BAS.USER_PROGRAM SELECT USER_ID,PRO_NO,-1,'S',0,GETDATE() FROM BAS.PROGRAM_INFO,BAS.USER_INFO WHERE USER_ID<10;