FullCount Database Subversion Repository
Introduction
FullCount has leveraged Subversion as a version control
tool. In this article, we're focusing on SQL scripts and
statements used for implementation of new customers, operational support
tasks, and other business critical functions.
Location
Conventions
Our basic naming convention is lower-case with underscores
using an intuitive name based on business process and/or specific use.
Scripts with the *.sql extension are stand-alone and can be executed as
an individual statement (may include variables for filters).
Scripts/files with the *.txt extension contain individual statements
along with other comments/content. These will need to be reviewed and
understood before using anything contained in the script/file.
Repository Structure (trunk)
|
Directory
|
Description
|
|
administration
|
Database Administration tasks such as database
configuration, space analysis, etc.
|
|
development
|
Application specific tasks specific to the FullCount
application suite.
|
|
processes
|
Ongoing business processes and tasks related to the
FullCount application suite.
|
|
reports
|
Reports/queries for use by the FullCount team but not
included in the FullCount application suite.
|
|
support
|
Ongoing support tasks for the FullCount application suite
on both remote and central servers.
|
|
tools
|
Custom tools/SQL currently in production on remote and
central servers.
|
Related Articles
FullCount Subversion Repositories
FullCount Subversion Repositories Introduction Subversion is a software tool for organizing and managing different versions of source code for computer programs. It is primarily used for managing plain text files such as source code, configuration ...
Subversion Guide
We use a version control software called Subversion. With this we can check out repositories, create branches, commit code changes, and do many other cool things. We don’t use the command line to interact with Subversion, rather we use TortoiseSVN, ...
Check Code Into Subversion
Instructions Once you have run your project and you are satisfied with your test results, you will want to check in code to our repository. All of our code is stored in a central repository hosted in our data center. The subversion tool, Tortoise ...
FullCount Office Network Information / Static IP Addresses
Network Info: Description Value(s) Wired Subnet 10.5.1.0/24 Wired DHCP Scope 10.5.1.20 - 10.5.1.170 Wired Default Gateway 10.5.1.254 Wireless Subnet 10.100.1.0/24 Wireless DHCP Scope 10.100.1.20 - 10.100.1.170 Wireless Default Gateway 10.100.1.254 ...
Run Baseline on Local XE Database
Objectives Import data from the latest dev database datadump into your local database. Prerequisites Local Oracle XE Database installed. Datapump utility installed (This comes with Oracle XE Database by default). Instructions Once per month on the ...