1、如果单纯的讲slapd.conf的配置棵褶佐峨还是比较简单的。 例子如下 ##### # sql database de熠硒勘唏finitions ###database sql suffix "o=sql,c=RU" rootdn "cn=root,o=sql,c=RU" rootpw secret dbname ldap_mysql dbuser root dbpasswd 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 updat髫潋啜缅es',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 joinsyscolumns 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