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!