createdatabase.cmd

来自「基于微软的 ASP.NET+C#开发的PETSHOP(网上宠物店)项目,在性能及」· CMD 代码 · 共 55 行

@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