createdatabase.cmd

基于微软的 ASP.NET+C#开发的PETSHOP(网上宠物店)项目,在性能及开发效率上明显优于基于SUN J2EE框架开发的PETSHOP. 项目包括所有源码及数据库建库脚本,是不错的学习 AS

@Echo Off

REM ***************************************************************************
REM **        File: CreateDatabase.cmd
REM **        Name: Database Setup
REM **        Desc: Database setup batch file.
REM **
REM **        Date: 1/12/2002
REM **
REM **************************************************************************/

REM Use the following section to set the server and sa password
REM of the SQL Server on which you want to create the database.
set SERVER=localhost
set LOGIN=sa
set PWD=
set DBNAME=petshop

@Echo.
@Echo *******************************************************************************
@Echo * Microsoft.NET PetShop Blueprint Application Database Setup                  *
@Echo *                                                                             *
@Echo *                                                                             *
@Echo * This script will create the .NET PetShop database and database objects.     *
@Echo * If you wish to cancel, press [CTRL]-C and terminate the batch job.          *
@Echo *                                                                             *
@Echo *******************************************************************************
@Echo. 
pause

@Echo.
@Echo.
@Echo *******************************************************************************
@Echo * Creating the Database...                                                    *
@Echo *******************************************************************************
@Echo. 
osql -S %SERVER% -U %LOGIN% -P %PWD% -d master -i PetShop_Schema.sql

@Echo.
@Echo.
@Echo *******************************************************************************
@Echo * Inserting the Data...                                                       *
@Echo *******************************************************************************
@Echo. 
osql -S %SERVER% -U %LOGIN% -P %PWD% -d %DBNAME% -i PetShop_DataLoad.sql

@Echo.
@Echo *******************************************************************************
@Echo *                                                                             *
@Echo * Database Setup Script Complete                                              *
@Echo *                                                                             *
@Echo *******************************************************************************
@Echo. 
pause