kesion4.5 ac转SQL与dvBBS8.1SQL整合,这个论坛里有那们做过?
我们只要非商业的程序啊!一切都是免费！
思路解析一下：
１．分别从官方免费下载最新的程序 Kesion4.5  /  Dvbbs8.1.1
２．在正常情况下按官方说明整合这两个程序的AC版!
３．每个程序单独转成SQL，SQL有这个功能，只要将AC的数据库转过来就行了！
４．认真检查每一个转过来的程序！会有错误的！

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
---------------------------------------------------------------------------------------------------------------------------------------
***************************************************************************************************************************************
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

本人能力有限，正在测试中，估计１月１２号能完成，在此请有过这方面经验的朋友帮帮忙，发表一下意见！
如果有这样的完整程序，不防共享一下！

[em80]

这是网上收的代码,还有一个是转好了的DV8.0的,呆会传个地址上来!

以下是代码片段：

[em80]

我们的原则就是:免费到家,免费到个人!
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dv_TSQL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Dv_TSQL]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dv_loadSetup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Dv_loadSetup]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dv_Dispbbs]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[dv_Dispbbs]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dv_list]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[dv_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dv_toplist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[dv_toplist]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [Dv_TSQL]
@tsql varchar(500)
AS
exec(@tsql)

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [Dv_loadSetup]

AS
Select * from [Dv_setup]

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dv_Dispbbs]
@boardid int=1,
@pagenow int=1, --当前页数
@pagesize int=1, --定义每页面帖子数目
@Announceid int=1,
@TotalUseTable nvarchar(10) ='Dv_bbs1'

AS
set nocount on
Select AnnounceID from [Dv_bbs1] Where BoardID=@BoardID And RootID=@Announceid Order By AnnounceID

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dv_list]
@boardid int=1,
@pagenow int=1, --当前页数
@pagesize int=1, --定义每页面帖子数目
@tl int=0, --按时间段查询
@topicmode int=0, --专题
@totalrec int output

AS
set nocount on
declare @int_topnum int
declare @int_timenum int
declare @var_times varchar(5000)

if @pagenow>1
if @topicmode>0
begin
select @int_timenum=(@pagenow-1)*@pagesize
set rowcount @int_timenum
select @var_times=lastposttime from Dv_Topic where mode=@topicmode and boardID=@boardID and istop = 0 ORDER BY lastposttime desc

set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from dv_topic where mode=@topicmode and boardID=@boardID and istop = 0 and lastposttime < @var_times ORDER BY lastposttime desc

set nocount off
return
end
else
begin
select @int_timenum=(@pagenow-1)*@pagesize
set rowcount @int_timenum
select @var_times=lastposttime from Dv_Topic where boardID=@boardID and istop = 0 ORDER BY lastposttime desc

set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from dv_topic where boardID=@boardID and istop = 0 and lastposttime < @var_times ORDER BY lastposttime desc

set nocount off
return
end

else
if @topicmode>0
begin
set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from Dv_topic where mode=@topicmode and boardID=@boardid and istop = 0 ORDER BY lastposttime desc
end
else
begin
set rowcount @pagesize
select TopicID,boardid,title,postusername,postuserid,dateandtime,child,hits,votetotal,lastpost,lastposttime,istop,isvote,isbest,locktopic,Expression,TopicMode,Mode,GetMoney,GetMoneyType,UseTools,IsSmsTopic,HideName from Dv_topic where boardID=@boardid and istop = 0 ORDER BY lastposttime desc
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dv_toplist]
@pagenow int ,
@pagesize int ,
@reture_value int output,
@intUserRecordCount int output
as
/*定义局部变量*/
declare @intBeginID int
declare @intEndID int
declare @intPageCount int
declare @intRowCount int

/*关闭计数*/
set nocount on

/*求总用户数*/
select @intUserRecordCount = count(*) from [dv_user]
if (@intUserRecordCount = 0) --如果没有用户，则返回零
set @reture_value =0

/*判断页数是否正确*/
if (@pagenow - 1) * @pagesize > @intUserRecordCount
set @reture_value =1
--return (-1)

/*求开始userID*/
set @intRowCount = (@pagenow - 1) * @pagesize + 1
/*限制条数*/
set rowcount @intRowCount
select @intBeginID = userid from [dv_user] order by userid desc

/*结束userID*/
set @intRowCount = @pagenow * @pagesize
/*限制条数*/
set rowcount @intRowCount
select @intEndID = userid from [dv_user] order by userid desc

/*恢复系统变量*/
set rowcount 0
set nocount off

select username,useremail,userclass,UserIM,UserPost,JoinDate,userwealth,userid from [dv_user] where userid between @intEndID and @intBeginID order by userid desc
return(@@rowcount)
--select @@rowcount

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

话不能这样说啊,你们看 一下,现在网上的Dvbbs8.1SQL的下载,在网上多的是,不在官方下载的是最近出来的,只要你懂点程序,对他们的程序多了解一点,修改起来是没问题的!
哎呀,我的那个做好了,就共享出来,大家不抢才怪哩!但是这个程序一定会是完整的,只做交流用,商业的话我就不能保证安全性,大家测试一下就知道了…………

呵呵，要这样下去，我也能开个公司了！呵呵

路过，走过，留下一点痕迹!!

支持北京奥运会-www.1mop.com
www.60300.com
www.5cn5.com

如果有人放存储过程版过来？那KS不是没得赚了？

只希望KS把老版本的存储过程版放过来就万分感谢咯。

好象科汛一直没有存储过程，只要是ACC/SQL通用这种程序一般都很难有存储过程吧，调用数据方式不一样，用免费ACC升级SQL最大区别在功能上，免费版有些功能是屏蔽了的不仅仅是个数据库的问题

是的，SQL版最关键的东西就在于有没有存储过程，如果没有存储过程，比起ACC版本，它只不过数据库本身承载能力加强了点而已，而程序和数据库运行却得不到质的飞跃！

不知道要到哪年哪月，才会有人放出SQL带存储过程的运行脚本，我们科汛迷们也只能拭目以待！！~

[此贴子已经被作者于2008-1-5 14:38:36编辑过]

个人认为SQL 与 ACC 最后的区别与好处在于 存储过程。

转变成SQL后。存储过程这块。。如果没有的话。跟ACC也没什么区别吧。

路过，听说可以通过以下方法升迁哦！~

CooSel2.0 CreateSQL V1.05

下载地址：http://www.jb51.net/downtools/db_create/DB_CreateSqlEV1.06.rar

档案包含 ASP 和 Exe 两个版本
Asp版本不支持直接导入到SQLserver,只支持脚本的编写
Exe 版本可以直接导入到SQLserver

功能：
生成升迁 SQL脚本，保存为 *.sql文件后，SQL2000的查询分析器里调入执行
生成升迁 ASP脚本，这样你可以用该脚本和相应MDB数据库上传到服务器在线升迁
直接执行Access数据导入到SQL2000服务器(表结构和数据)

[此贴子已经被作者于2008-1-5 14:32:44编辑过]