Catalog · How the catalog works
SCM_BuildMeAClub-R
BuildMeAClub creates the SwimClubMeet database in MS SQLEXPRESS and populates it with starter data. Part of the SCM eco system of swimming club applications.
- ★ 3 on GitHub
Anyone may press Interesting, signed in or not. It helps others find this project.
README
# SCM_BuildMeAClub RELEASE
BuildMeAClub (BMAC) is an application that creates the SwimClubMeet database in MS SQLEXPRESS and populates it with starter data
BMAC is a 64bit application written in pascal. It's part of an eco system of applications that make up the SwimClubMeet project. SCM lets amateur swimming clubs manage members and run their club night's.
To learn more about SCM view the github pages.
If you are interested in following a developer's blog and track my progress then you can find me at ko-fi.
USING BMAC
BMAC is a universal SwimClubMeet database builder. It looks for SQL scripts located in the BMAC_SCRIPTS sub-folder (located in the application's install directory). Each database version is assigned a state - RELEASE, PRE-RELEASE and DEPRECIATED.
BMAC will not overwrite an existing SwimClubMeet database.
BMAC uses the SQL command utility, sqlcmd.exe. If you are using this application to create the database on a remote database server, then sqlcmd.exe must be correctly pathed.
sqlcmd.exe is installed by default when you install MS SQLEXPRESS.
ON START-UP
The 'Build Me A Club' button will not be enabled until a connection to the database server has been established and a database version has been selected.
Steps to build your database:
Step 1: Connect to the database. (Connects to root, thereby checking you have MS SQLEXPRESS installed.)Step 2: Click 'Select Database Build' and select the 'build'.Step 3: Once connected and a 'Build' is selected, the 'Build Me a Club' button will be enabled.
Click the button to start the build.SHOULD THE BUILD FAIL : ERRORS?
Any errors created by sqlcmd.exe are displayed in BMAC's text window.
A server side log file is also produced. This will be located in your documents folder with the filename SCM_BuildMeAClub.log.
The log file is not removed on uninstall. This is intentional.
OTHER NOTES
See the Wiki for info on the match-up of SCM applications with SCM database. WIKI: Version Info.
You would only ever need to run this application once. After a successful build the application can be removed. 😃
Use Windows Apps and Features to remove the application.
A utility call SCM_UpdateDatabase is available to progress to other versions as they become available.
