1、如果单纯的讲slapd.conf的配置还是比较简单的。例子如下###### sql database definitions###database sqlsuffix "o=sql,c=RU"rootdn "cn=root,o=sql,c=RU"rootpw secretdbname ldap_mysqldbuser rootdbpasswd subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"insentry_stmt "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)"has_ldapinfo_dn_ru no
2、在批量的修改表名和列名的时候，需要更新系统表。需要对其进行配置。测试用例：
------启用对系统目录的特殊更新USE mastersp_configure 'allow updates',1GORECONFIGURE WITH OVERRIDEGOuse code_tmpupdate sysobjectsset name = rtrim(a.英文名称)from code_tmp.dbo.表名对照$ as a inner joinsysobjects bon b.name = rtrim(a.代码表)where b.xtype = 'u'
select * from syscolumns where id in (select id from sysobjects where xtype = 'u')
select * from dbo.Drainage_Type
3、--禁用对系统目录的特殊更新USE masterGOsp_configure 'allow updates', 0GORECONFIGURE WITH OVERRIDEGO----select * from dbo.字段对照表$select * from syscolumns where id in (select id from sysobjects where xtype = 'u')
4、--启用对系统目录的特殊更新USE mastersp_configure 'allow updates',1GORECONFIGURE WITH OVERRIDEGOuse code_tmpupdate syscolumnsset name =rtrim(a.英文名)from code_tmp.dbo.字段对照表$ as a inner join syscolumns as bon rtrim(a.字段名)=b.namewhere b.id in(select id from sysobjects where xtype = 'u')
5、--禁用对系统目录的特殊更新USE masterGOsp_configure 'allow updates', 0GORECONFIGURE WITH OVERRIDEGO