KingCMS 3.0 的AC数据库转成MSSQL的方法

一、准备工作：
1、备份AC数据库及conn.asp文件（啰嗦一句：每位合格的站长都有备份数据的习惯）；
2、在 KingCMS官方站下载KingCMS BETA 1118（即最新的KingCMS 3.0）
3、将 INSTALL.asp 放到后台目录下，并执行安装一个空的MS SQL库。安装方法见KingCMS 3.0 如何安装MSMSQL数据库

二、开始转换
1、使用 企业管理器 链接到MS SQL（一定要使用系统分配的帐号登陆，以免转换后出现读取的权限错误）；
2、删除以下表中的数据： kingadmin   kingsystem   kingkey  kinglevel
<SPAN id=attach_3989 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 475px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_707ed10e70a26f829084C08N4f2cR32i.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3989', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3989', 0, event)" />
<SPAN id=attach_3990 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 863px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_0785b4f84b70fae30325351EydyOIIb7.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3990', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3990', 0, event)" />

3、导入数据如图示
<SPAN id=attach_3991 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 1272px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_d645236fe78961eb8960R2Fi84Y5V6Kv.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3991', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3991', 0, event)" />
<SPAN id=attach_3992 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 1503px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_de042a95e8b29277bad7e0AGS2PKaVsC.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3992', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3992', 0, event)" />
<SPAN id=attach_3993 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 1878px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_48be31667e3fbba3ec20zcoUSsTz14ve.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3993', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3993', 0, event)" />
<SPAN id=attach_3994 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 2261px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_53473b16611f2f75b34ccZYo5vEV37AI.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3994', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3994', 0, event)" />
<SPAN id=attach_3995 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 2647px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_b488e877e66f48bc76f8ZUNqbYWcKFgR.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3995', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3995', 0, event)" />
<SPAN id=attach_3996 style="DISPLAY: none; LEFT: 217px; POSITION: absolute; TOP: 3034px" .mouseover="showMenu(this.id, 0, 1)"> <img alt="" src="http://www.adjie.com/attachments/forumid_38/20070903_6b0b41ee78380b6b6b85YXDO2CgXWbpd.jpg" border=0 .mouseover="attachimginfo(this, 'attach_3996', 1);attachimg(this, 'mouseover')" .load="attachimg(this, 'load')" .mouseout="attachimginfo(this, 'attach_3996', 0, event)" />