createdatabase.cmd

幼儿园管理软件aspSPOS幼儿园办公管理系统2.00普及版安装说明： 一. 安装前提条件： 1. 在安装SPOS幼儿园办公管理系统2.00普及版之前

@Echo Off

REM ***************************************************************************
REM **        File: CreateDatabase.cmd
REM **        Name: Database Setup
REM **        Desc: Database setup batch file.
REM **
REM **        Date: 1/1/2003
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=spos

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


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



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



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