Lawtrac Application Database

SQL Server Management Studio should be utilized to create the databases. Once the database has been configured, the scripts must be run against each database being created.

Client Storage Database

To facilitate the storage of client variables created from the day-to-day use of the Lawtrac application, the Client Storage database must be created as the repository.

Setting Up the Client Storage Database

• Open the Lawtrac Installation Directory and run Create_1_Database_Tables.sql, Create_2_Constraints.sql, Create_3_Default_Data.sql, Create_4_Upgrade_Data.sql,and Create_5_BankersRounding.sql.on the recently created Client Storage database.

Currency Database

The currency database must be created to enter invoices into Lawtrac. This database is not used to store data entered through the application; the Lawtrac application reads the tables in the Currency database to obtain exchange rates.

Setting Up the Currency Database

• Open the Lawtrac Installation Directory and run Create_Currency_Databases.sqlon the recently created Currency database.

If foreign currency invoices will be entered, a nightly XML data feed is required to populate the Currency database with current exchange rates. Additional code is available to send an HTTP request to receive exchange rate data. Note that firewall settings may require an adjustment. If your company is interested in receiving a daily exchange feed, please refer to the Setting-up International Currency Exchange Feed section of this document.

Activity Database

**This process is required

To facilitate the user activity audit tracking feature incorporated in the application, the Activity database must be created to store this information. 

Setting Up the Activity Database

• Open the Lawtrac Installation Directory and run Create_Optional_Activity.sql on the recently created Activity database.

Point Database to Codebase

**This process is required.

Execute the following query in New/Upgraded Lawtrac database to customize the Login URL and Company Logo URL. 

Update CorpInfo

Execute the following query in New/Upgraded Lawtrac database to customize the Login URL and Company Logo URL.

1. SET INTUrl = "http://localhost:8500/YourLawtracVersion/". For example, a Lawtrac 4.3 user would enter: http://localhost:8500/Lawtrac43/
2. CorpLogoURL = "http://localhost:8500/YourLawtracVer...s/Corplogo.gif" // or a client default image. For For example, a Lawtrac 4.3 user would enter: "http://localhost:8500/Lawtrac43/ima...s/Corplogo.gif
   WHERE TableID = 1