New AccuSQL Website Launched!

We have a brand new site for AccuSQL. Visit http://www.accusql.com to learn all about it.

Are you looking for SQL Server software to track your students and manage your services? If so, we have good news for you. AccuTrack now has a SQL Server back-end option!

What is it?

In response to requests from IT departments in several colleges and universities, we created a version of AccuTrack that utilizes Microsoft SQL Server as its back-end instead of the traditional Microsoft Visual FoxPro that AccuTrack used for the past ten years. While Visual FoxPro is a highly capable database engine, the SQL Server is more robust and faster database engine and works better for colleges that want to utilize AccuTrack at the enterprise level.

How did you create it?

To create AccuSQL, our developers spent countless hours over a 6-month period converting thousands of AccuTrack version 10 database calls so they would work with the SQL Server. This was a major undertaking because of the enormous size of AccuTrack. Over 200 screens, 100 free-standing programs, and 40 programming classes had to be converted. These contain thousands of database calls. Since each data call is different, it needed to be examined and converted manually, and of course tested exhaustively to verify it works.

Is is faster?

Our tests have shown that AccuSQL runs much faster, especially over the network. The reason for this is that the data filtering and other manipulations are done at the server-side, thus only the results of these are transferred across the network.

For example, let’s say you want to view the record of a certain student. With the current AccuTrack version, the software will first download the student index, which for large installations could be a few megabytes in size, and it will then locate the student’s record via this index and then get it from the student table. With an SQL Server, AccuSQL would not need to download the index. Rather, it just asks for that student’s record, then SQL Server does all the work and passes the student’s record to the software!

What other advantages does AccuSQL offer?

In addition to the speed advantage, the SQL Server database is more robust. This means you will no longer need to worry about possible database index corruption caused by improper shutdowns. Actually, AccuSQL does not even have a “Database Repair” utility.

Another advantage is that your SQL Server database administrator (DBA) can use traditional SQL Server query tools on the AccuSQL database. With this capability, the DBA can manipulate the data and create custom reports if needed.

Also, by accessing your SQL Server over the web, you will be able to run AccuSQL from anywhere you like. For example, you will be able to run AccuSQL from home while connecting it to your SQL Server using a standard IP connection!

What do I need?

To use AccuSQL, you will need Microsoft SQL Server 2005/2008 (either express, or standard). You will also need a SQL Server DBA (Database Administrator) account for installing and setting up your SQL Server database. Of course, you will also need a license of AccuSQL.

What if I am already an AccuTrack user?

If you currently use AccuTrack, then you have some great advantages:

1. You already know how to use the software. AccuSQL is built on AccuTrack 10, so the features and interface of the SQL back-end version is identical to AccuTrack 10.

2. You can use your current AccuTrack data. We will provide you with a utility that will move your current AccuTrack FoxPro database into the SQL Server database, so you current database will be completely ported to the SQL Server database automatically!

3. You will get a considerable credit. AccuTrack 10 users get 100% credit for their AccuTrack FoxPro licensing fees to be used towards their AccuSQL version. Users of older versions of AccuTrack (9 or older), will also get credit towards the AccuSQL version license. The amount of this credit depends on the version and type of license. Check with our sales department for a quote.

How much does it cost?

For a price quote on your AccuSQL Version license, please contact your sales representative.