Posted by Oscar Santiesteban Jr. on 09/09/05 04:43

Phil,

We have been using a Billing system for the City's Water, Sewer, Garbage,
and Storm Water for the past 6 years. We started using this system when
Great Plains was still their own company, and not part of Microsoft. The
system has never had any problems. I run a DBCC on the database, and
reindex every weekend. I do full backups every night and transaction log
backups every hour. We have never had a need to call Great Plains, we
mainly called our vendor with problems in the software. You will notice
however that the Great Plains developers were smoking some bad weed when
they developed this system. Any system that names their tables with
"zx00012234" for example are crazy. The people of Remedy (formerly of
Peregrine) also suffer from halucinations and also use this crazy method.

Just as an FYI, the Great Plains system is developed in a language called
"DEXTERITY". There is some sort of VBA add-in which will allow you to
develop forms in Visual Basic.


"TheScullster" <phil@dropthespam.com> wrote in message
news:A8mdnRQUcufeMoDeSa8jmw@karoo.co.uk...
> Hi all
>
> Sorry if this is such a mega dumb question for this group, but what
exactly
> is involved in maintaining/supporting a SQL database?
>
> My company is looking at accounting software "Great Plains" which they
> intend to run on SQL server.
> Having only had experience of a split Access database, this is something
of
> a quantum leap for me!
> The only maintenance I do on the Access version is a scheduled nightly
> compact/repair on the back end and have the front ends set to compact on
> close.
>
> So what is involved with the SQL database?
> Is it straightforward, or should I be talking the company into paying for
> yet more "maintenance/support" for someone to remote in weekly and perform
a
> similar function?
>
> Any help appreciated.
>
> Phil
>
>

[Back to original message]