ArgusConnect has no plans to replace Firebird Interbase with MSSQL.
That said, DHS Victoria runs Argus on MSSQL.
A
Horst Herb wrote:
On Friday 16 February 2007 15:17, Andrew N. Shrosbree wrote:
I share Russel's frustration about being forced to do major upgrades after
hours. Argus has the same problem, which is caused by a deficiency in
Interbase. There is simply no elegant way to disconnect all users before
performing tasks as drastic as making structural changes to database
tables. All users of Interbase will face this problem. That means ZMed,
Argus, Medtech, Profile AFAIK. For what it's worth, users of Microsoft
SequelServer don't have this problem
Nor does Postgresql.
At the time when you chose INterbase as server it was probably the best option
available, with Psotgresql not running well on Windows.
Things have changed since. PostgreSQL runs now equally well on Windows, has
better libraries available for most languages, is a lot easier to
administrate, and with maybe the exception of Oracle is the safest one
overall to do anything drastic with it while it is in full use (due to it's
multi-generational approach to changes and write-ahead logging)
With MSSQL you woudl immediately alienate sme of your staunchest supporters
and exldue a percentage of your already exisiting user base - whereas
Postgresql could be a single-click upgrade option that will prevent future
problems.
All that said - as long as you don't change table structure beyond adding
fields while in use (you can do that safely in Postgres), reindex while in
use (again safe in Postgres), or change trigger procedures while in use (not
safe in any system, not possible to make safe) there should not really be a
problem anyway.
Horst
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
--
Andrew N. Shrosbree B.Sc, B.Ec
Technical Architect
ArgusConnect Pty Ltd
http://www.argusconnect.com.au
Mob: +61 (0)415 645 291
Skype: andrewshroz
|
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
