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!