|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > SQL 7.x w/ WIN2K pro
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 7.x w/ WIN2K pro
|
|
|
| We use a DOS based program for HR,AR, AP etc. Our vendor
says we need to upgrade to SQL 2000i for fear of data
corruption. Any one else have an issue with this. It all
appears to be working fine. Thanks for the help
| |
| Geoff N. Hiten 2002-08-14, 6:23 am |
| Your DOS based program (like all dos-type apps) relies on each client to
maintain data integrity. If a client crashes unexpectedly, data corruption
can occur. SQL 2000 runs as a service on a host computer, and maintains
data integrity through use of a write-ahead log and transactional recovery,
so there is some truth in his statements. The vendor may be pushing the new
technology to reduce his support costs as well as protect your data. While
upgrading just for the sake of upgrading isn't a good business practice
(unless you are SELLING the upgrades), you may be stuck with orphan
technology if you don't. Then upgrading gets expensive since you have to
pay specialists to convert systems and data.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Mike" <mmontore@sau27.net> wrote in message
news:328201c24381$05d2abd0$9ae
62ecf@tkmsftngxa02...
> We use a DOS based program for HR,AR, AP etc. Our vendor
> says we need to upgrade to SQL 2000i for fear of data
> corruption. Any one else have an issue with this. It all
> appears to be working fine. Thanks for the help
| |
| John Bell 2002-08-14, 10:23 am |
| "Mike" <mmontore@sau27.net> wrote in message news:< 328201c24381$05d2abd0$9ae62ecf
@tkmsftngxa02>...
> We use a DOS based program for HR,AR, AP etc. Our vendor
> says we need to upgrade to SQL 2000i for fear of data
> corruption. Any one else have an issue with this. It all
> appears to be working fine. Thanks for the help
Hi
I don't have specific experience with dos based programs, but unless
your vendor can give you detailed example of when this has occurred
and why, you are not going to be able to assess your own risk.
SQL7 still has a large user base and is well supported by MS. As far
as I know there are no plans to phase it out (but I am sure someone
will correct me if that is wrong!).
If you are not going to change or upgrade anything other than the
database I don't really see the point. If your vendor want you to
upgrade from the DOS versions then you should also consider what
options you have from other vendors!
John
| |
| Neil Pike 2002-08-14, 12:23 pm |
| This is a generic thing rather than something specific to that product.
Anything that uses shared "flat" files rather than a dbms for multi-user use is
always going to have a window of opportunity for corruption when software or
hardware errors occur.
> We use a DOS based program for HR,AR, AP etc. Our vendor
> says we need to upgrade to SQL 2000i for fear of data
> corruption. Any one else have an issue with this. It all
> appears to be working fine. Thanks for the help
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
|
|
|
|
|