现在好多程序，都是与数据库相关的，因此在做安装的时候，部署数据库看似是一件很复杂的事情。其实就我个人而言，部署数据库是很简单，大致的思路如下：
1． 用本身的dbms来产生数据库创建的sql脚本；
2． 接下来就是写程序来执行sql脚本，从而达到创建数据库的目的。
以下用一个举例来说明，数据库服务器用的是sql server。
首先要在数据库生成好的sql脚本最前头，加入如下语句：
use master
go
if exists (select * from sysdatabases where name='mytest')
drop database mytest
go
create database mytest
go
use mytest
go
注：其中“mytest”是要创建的数据库名。
而程序的代码如下：
//---------------------------create db-------------------------------------
//-------------------------------------------------------------------------
//---file:frmcreatedb.cs
//---description:the main form file to create database using specific sql file
//---author:knight
//---date:mar.18, 2006
//-------------------------------------------------------------------------
//-------------------------{ create db }-----------------------------------
using system;
using system.drawing;
using system.collections;
using system.componentmodel;
using system.windows.forms;
using system.data;
using system.data.sqlclient;
using system.io;
namespace createdb
{
///<summary>
/// summary description for frmcreatedb.
///</summary>
public class frmcreatedb : system.windows.forms.form
{
private system.windows.forms.label label1;
private system.windows.forms.textbox txtservername;
private system.windows.forms.label label2;
private system.windows.forms.label label3;
private system.windows.forms.textbox txtusername;
private system.windows.forms.textbox txtpassword;
private system.windows.forms.button btncreatedb;
///<summary>
/// required designer variable.
///</summary>
private system.componentmodel.container components = null;
public frmcreatedb()
{
//
// required for windows form designer support
//
initializecomponent();
//
// todo: add any constructor code after initializecomponent call
//
}
///<summary>
/// clean up any resources being used.
///</summary>
protected override void dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.dispose();
}
}
base.dispose( disposing );
}
#region windows form designer generated code
///<summary>
/// required method for designer support - do not modify
/// the contents of this method with the code editor.
///</summary>
private void initializecomponent()
{
this.label1 = new system.windows.forms.label();
this.txtservername = new system.windows.forms.textbox();
this.txtusername = new system.windows.forms.textbox();
this.label2 = new system.windows.forms.label();
this.txtpassword = new system.windows.forms.textbox();
this.label3 = new system.windows.forms.label();
this.btncreatedb = new system.windows.forms.button();
this.suspendlayout();
//
// label1
//
this.label1.autosize = true;
this.label1.location = new system.drawing.point(32, 32);
this.label1.name = "label1";
this.label1.size = new system.drawing.size(74, 16);
this.label1.tabindex = 0;
this.label1.text = "server name:";
//
// txtservername
//
this.txtservername.location = new system.drawing.point(120, 32);
this.txtservername.name = "txtservername";
this.txtservername.size = new system.drawing.size(152, 20);
this.txtservername.tabindex = 1;
this.txtservername.text = "";
//
// txtusername
//
this.txtusername.location = new system.drawing.point(120, 64);
this.txtusername.name = "txtusername";
this.txtusername.size = new system.drawing.size(152, 20);
this.txtusername.tabindex = 3;
this.txtusername.text = "";
//
// label2
//
this.label2.autosize = true;
this.label2.location = new system.drawing.point(40, 64);
this.label2.name = "label2";
this.label2.size = new system.drawing.size(64, 16);
this.label2.tabindex = 2;
this.label2.text = "user name:";
//
// txtpassword
//
this.txtpassword.location = new system.drawing.point(120, 96);
this.txtpassword.name = "txtpassword";
this.txtpassword.passwordchar = '*';
this.txtpassword.size = new system.drawing.size(152, 20);
this.txtpassword.tabindex = 5;
this.txtpassword.text = "";
//
// label3
//
this.label3.autosize = true;
this.label3.location = new system.drawing.point(48, 96);
this.label3.name = "label3";
this.label3.size = new system.drawing.size(57, 16);
this.label3.tabindex = 4;
this.label3.text = "password:";
//
// btncreatedb
//
this.btncreatedb.location = new system.drawing.point(168, 136);
this.btncreatedb.name = "btncreatedb";
this.btncreatedb.size = new system.drawing.size(104, 23);
this.btncreatedb.tabindex = 6;
this.btncreatedb.text = "&create db";
this.btncreatedb.click += new system.eventhandler(this.btncreatedb_click);
//
// frmcreatedb
//
this.autoscalebasesize = new system.drawing.size(5, 13);
this.clientsize = new system.drawing.size(306, 175);
this.controls.add(this.btncreatedb);
this.controls.add(this.txtpassword);
this.controls.add(this.label3);
this.controls.add(this.txtusername);
this.controls.add(this.label2);
this.controls.add(this.txtservername);
this.controls.add(this.label1);
this.formborderstyle = system.windows.forms.formborderstyle.fixedsingle;
this.maximizebox = false;
this.name = "frmcreatedb";
this.startposition = system.windows.forms.formstartposition.centerscreen;
this.text = "create db";
this.resumelayout(false);
}
#endregion
///<summary>
/// the main entry point for the application.
///</summary>
[stathread]
static void main()
{
application.run(new frmcreatedb());
}
private void btncreatedb_click(object sender, system.eventargs e)
{
sqlconnection sqlconn = new sqlconnection();
try
{
sqlcomm.executenonquery();
return true;
}
catch( sqlexception sqlerr )
{
messagebox.show( sqlerr.message );
}
catch
{
}
sqlcomm.dispose();
}
return true;
}
}
}
要注意的是在sql脚本中的“/r/n”，在sqlcommand中是无法识别，因此要替换为空格；其次“go” 在sqlcommand中也是无法识别，但为了使每条语句都执行，因此我在这里，用“；”来替换。
注：程序的位置和sql脚本文件的位置为同一目录下，如果觉得不方便的话，可以在我的基础上再延伸。
新闻热点
疑难解答
