home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DOS/V Power Report 2000 March
/
VPR0003B.ISO
/
i386
/
buildbcp.cmd
< prev
next >
Wrap
OS/2 REXX Batch file
|
1999-10-14
|
2KB
|
47 lines
cls
@echo off
echo --------------------------------------------------------------------
echo Exploration Air Sample Site SQL Server Build BCP script (v1.04.0912)
echo --------------------------------------------------------------------
echo.
echo This batch file builds the initial SQL Server BCP files from
echo the ExAir databases. It is not for general use.
echo.
echo Usage is:
echo.
echo BuildBCP.cmd
echo.
echo Note there are some assumptions:
echo 1) SQL Server is located in c:\mssql\
echo 2) The admin account is SA with no password
echo.
set SRV=%COMPUTERNAME%
echo About to build BCP files on '%SRV%'
echo.
pause
echo.
echo Building BCP files
bcp ExAir..Ads out Ads.bcp -S%SRV% -Usa -P -n
bcp ExAir..AdsInterests out AdsInterests.bcp -S%SRV% -Usa -P -n
bcp ExAir..Company out Company.bcp -S%SRV% -Usa -P -n
bcp ExAir..Destination out Destination.bcp -S%SRV% -Usa -P -n
bcp ExAir..FlightSchedule out FlightSchedule.bcp -S%SRV% -Usa -P -n
bcp ExAir..InterestCategories out InterestCategories.bcp -S%SRV% -Usa -P -n
bcp ExAir..Interests out Interests.bcp -S%SRV% -Usa -P -n
bcp ExAir..Member out Member.bcp -S%SRV% -Usa -P -n
bcp ExAir..Membership out Membership.bcp -S%SRV% -Usa -P -n
bcp ExAir..MembershipType out MembershipType.bcp -S%SRV% -Usa -P -n
bcp ExAir..MembersInterests out MembersInterests.bcp -S%SRV% -Usa -P -n
bcp ExAir..Promotions out Promotions.bcp -S%SRV% -Usa -P -n
bcp ExAir..PromotionsInterests out PromotionsInterests.bcp -S%SRV% -Usa -P -n
bcp ExAir..Special out Special.bcp -S%SRV% -Usa -P -n
bcp ExAir..TakeANumber out TakeANumber.bcp -S%SRV% -Usa -P -n
bcp ExAir..Transactions out Transactions.bcp -S%SRV% -Usa -P -n
bcp ExAir..TransactionType out TransactionType.bcp -S%SRV% -Usa -P -n
Echo Done!