求net打包自动安装数据库的问题！！！！！！！
做了一个asp.net网站，经理让我把它做成安装文件，而且还要把数据库打包进去，我也去查过资料，但是都是应用程序的打包问题，很少有关于.net2005的网站安装步骤，请各位帮忙，能有例子的话就更好，谢谢了！对了，用的是mssql2000。
－－－－－－－在线等！
[解决办法]
一般都是安装的时候执行Sql脚本文件吧
[解决办法]
在贴子中可以找到。安装制作类:
Imports System.ComponentModel
Imports System.Configuration.Install
Imports System.IO
Imports System.Reflection
<RunInstaller(True)> Public Class DBCustomAction
Inherits System.Configuration.Install.Installer
#Region "组件设计器生成的代码 "
Public Sub New()
MyBase.New()
'该调用是组件设计器所必需的
InitializeComponent()
'在 InitializeComponent() 调用之后添加任何初始化
End Sub
' Installer 重写 dispose 以清理组件列表。
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub
Private components As System.ComponentModel.IContainer
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
#End Region
'执行SQL 语句
Private Sub ExecuteSql(ByVal conn As String, ByVal DatabaseName As String, ByVal Sql As String)
Dim mySqlConnection As New SqlClient.SqlConnection(conn)
Dim Command As New SqlClient.SqlCommand(Sql, mySqlConnection)
Command.Connection.Open()
Command.Connection.ChangeDatabase(DatabaseName)
Try
Command.ExecuteNonQuery()
Finally
'Close Connection
Command.Connection.Close()
End Try
End Sub
Public Overrides Sub Install(ByVal stateSaver As System.Collections.IDictionary)
MyBase.Install(stateSaver)
' ------------------------建立数据库-------------------------------------------------
Try
Dim connStr As String = String.Format( "data source={0};user id={1};password={2};persist security info=false;packet size=4096 ", Me.Context.Parameters.Item( "server "), Me.Context.Parameters.Item( "user "), Me.Context.Parameters.Item( "pwd "))
'根据输入的数据库名称建立数据库
ExecuteSql(connStr, "master ", "CREATE DATABASE " + Me.Context.Parameters.Item( "dbname "))
'调用osql执行脚本
Dim sqlProcess As New System.Diagnostics.Process
sqlProcess.StartInfo.FileName = "osql.exe "
sqlProcess.StartInfo.Arguments = String.Format( " -U {0} -P {1} -d {2} -i {3}db.sql ", Me.Context.Parameters.Item( "user "), Me.Context.Parameters.Item( "pwd "), Me.Context.Parameters.Item( "dbname "), Me.Context.Parameters.Item( "targetdir "))
sqlProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden
sqlProcess.Start()
sqlProcess.WaitForExit() '等待执行
sqlProcess.Close()
'删除脚本文件
Dim sqlFileInfo As New System.IO.FileInfo(String.Format( "{0}db.sql ", Me.Context.Parameters.Item( "targetdir ")))
If sqlFileInfo.Exists Then
sqlFileInfo.Delete()
End If
Catch ex As Exception
Throw ex
End Try
' ---------------------将连接字符串写入Web.config-----------------------------------
Try
Dim FileInfo As System.IO.FileInfo = New System.IO.FileInfo(Me.Context.Parameters.Item( "targetdir ") & "\web.config ")
If Not FileInfo.Exists Then
Throw New InstallException( "没有找到配置文件 ")
End If
'实例化XML文档
Dim XmlDocument As New System.Xml.XmlDocument
XmlDocument.Load(FileInfo.FullName)
'查找到appSettings中的节点
Dim Node As System.Xml.XmlNode
Dim FoundIt As Boolean = False
For Each Node In XmlDocument.Item( "configuration ").Item( "appSettings ")
If Node.Name = "add " Then
If Node.Attributes.GetNamedItem( "key ").Value = "connString " Then
'写入连接字符串
Node.Attributes.GetNamedItem( "value ").Value = String.Format( "Persist Security Info=False;Data Source={0};Initial Catalog={1};User ID={2};Password={3};Packet Size=4096;Pooling=true;Max Pool Size=100;Min Pool Size=1 ", _
Me.Context.Parameters.Item( "server "), Me.Context.Parameters.Item( "dbname "), Me.Context.Parameters.Item( "user "), Me.Context.Parameters.Item( "pwd "))
FoundIt = True
End If
End If
Next Node
If Not FoundIt Then
Throw New InstallException( "web.Config 文件没有包含connString连接字符串设置 ")
End If
XmlDocument.Save(FileInfo.FullName)
Catch ex As Exception
Throw ex
End Try
End Sub
End Class
[解决办法]
一大堆
http://www.aspxboy.com/2/category.aspx
http://www.aspxboy.com/private/504/default.aspx
[解决办法]
写一个InstallDataBase.cmd文件，在安装的时候运行该命令脚本
文件基本结构如下：
@Echo Off
cls
@Echo
*******************************************************************************
@Echo * Creating Databases... *
@Echo *******************************************************************************
@Echo.
osql -E -i CreateDatabase1.sql
osql -E -i CreateDatabase2.sql
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -A all -d YourDataBaseNameServices
@Echo *******************************************************************************
@Echo * Creating Tables... *
@Echo *******************************************************************************
@Echo.
osql -E -i CreateTables1.sql
osql -E -i CreateTables2.sql
@Echo *******************************************************************************
@Echo * Loading Data... *
@Echo *******************************************************************************
@Echo.
osql -E -i InsertData.sql
@Echo
*******************************************************************************
@Echo * Registering Databases for SQL Cache Dependency...
*
@Echo *******************************************************************************
@Echo.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d 数据库名 -ed
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d 数据库名 -t 表1名 -et
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d 数据库名 -t 表2名 -et
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d 数据库名 -t 表3名 -et
@Echo *******************************************************************************
@Echo * *
@Echo * Database Setup Complete *
@Echo * *
@Echo *******************************************************************************
@Echo.
pause
Sql脚本文件放在与cmd文件同目录下或子目录下都可以，只是注意运行Sql脚本时使用相对路径就可以了。希望对你有所帮助
