Discuz!NT 2.5 Sql数据库转换为Access数据库

Discuz!NT2.5本身带的access数据库有些小问题，分别是

1. dnt_templates   自动增长
2. dnt_topics  hide->poll(数字)
3. dnt_usergroups  自动增长

要自己先把这些自动改一下。或者可以下载附件里面那个模板数据库。
代码见下：

1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
5. using System.Data;
6. using System.Data.SqlClient;
7. using System.Data.OleDb;
8. using System.IO;
10. namespace DBcpy
11. {
12.     class Program
13.     {
14.         static void Main(string[] args)
15.         {
16.             SqlConnection SqlConn = new SqlConnection(@"Server=*;database=*;Trusted_Connection=SSPI");
17.             OleDbConnection OleConn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:/*;Persist Security Info=True;");
18.             SqlCommand SqlCmd = null;
19.             OleDbCommand OleCmd = null;
20.             SqlDataReader SqlDR = null;
21.             OleDbDataReader OleDR = null;
23.             SqlConn.Open();
24.             OleConn.Open();
25.             string sql = string.Empty;
26.             sql = "select name from sysobjects where type='u'";
27.             SqlCmd = new SqlCommand(sql, SqlConn);
28.             SqlDR = SqlCmd.ExecuteReader();
29.             List<String> TabList = new List<string>();
30.             while(SqlDR.Read())
31.                 TabList.Add(SqlDR[0].ToString());
32.             SqlDR.Close();
33.             TabList.Sort();
34.             foreach(string TabName in TabList)
35.             {
36.                 List<string> ColList = new List<string>();
37.                 string Identity = string.Empty;
38.                 sql = string.Format("EXEC sp_help {0}", TabName);
39.                 SqlDR = new SqlCommand(sql, SqlConn).ExecuteReader();
40.                 SqlDR.NextResult();
41.                 while(SqlDR.Read())
42.                     ColList.Add(SqlDR[0].ToString());
43.                 SqlDR.NextResult();
44.                 while(SqlDR.Read())
45.                 {
46.                     Identity = SqlDR[0].ToString();
47.                     if(Identity == "No identity column defined.")
48.                         Identity = string.Empty;
49.                     else
50.                         ColList.Remove(Identity);
51.                 }
52.                 SqlDR.Close();
53.                 sql = string.Format("select * from {0}", TabName);
54.                 if(!string.IsNullOrEmpty(Identity))
55.                     sql += " order by " + Identity;
56.                 SqlDR = new SqlCommand(sql, SqlConn).ExecuteReader();
57.                 int ID = 0;
58.                 while(SqlDR.Read())
59.                 {
60.                     string f1 = string.Empty, f2 = string.Empty;
61.                     foreach(string field in ColList)
62.                     {
63.                         f1 += string.Format(",[{0}]", field);
64.                         f2 += string.Format(",/'{0}/'", SqlDR[field].ToString().TrimEnd().Replace("'", "''"));
65.                     }
66.                     if(!string.IsNullOrEmpty(Identity))
67.                     {
68.                         int tID = int.Parse(SqlDR[Identity].ToString());
69.                         for(int i = ID + 1;i < tID;i++)
70.                         {
71.                             sql = string.Format("insert into {0}({1}) values({2})", TabName, f1.Remove(0, 1), f2.Remove(0, 1));
72.                             OleCmd = new OleDbCommand(sql, OleConn);
73.                             OleCmd.ExecuteNonQuery();
74.                             sql = string.Format("delete from {0} where {1}={2}", TabName, Identity, i);
75.                             OleCmd = new OleDbCommand(sql, OleConn);
76.                             OleCmd.ExecuteNonQuery();
77.                         }
78.                         ID = int.Parse(SqlDR[Identity].ToString());
79.                     }
80.                     sql = string.Format("insert into {0}({1}) values({2})", TabName, f1.Remove(0, 1), f2.Remove(0, 1));
81.                     OleCmd = new OleDbCommand(sql, OleConn);
82.                     OleCmd.ExecuteNonQuery();
83.                 }
84.                 SqlDR.Close();
85.             }
88.             OleConn.Close();
89.             SqlConn.Close();
90.         }
91.     }
92. }

代码和模板数据库下载地址： http://download.csdn.net/source/939867
本人水平有限，不保证此代码没有Bug。但是经过多次测试，目前还没有发现Bug。如果发现了Bug，欢迎指出。