Hi Gary. One HUGE thing we have found at work to be a MAJOR problem is that
if you use the SQL 7 upgrade wizard and your database has usernames and
passwords as I am sure it does, is that it maps the WRONG username with the
WRONG password !!! you can imagine the HUGE imbarisment that has caused us!!
its really hard to Blame MS for this, the client tends to go deaf at about
that point !
We have not found a solution to the problem, and MS are looking into it, but
basically BEWARE !!! as it means typing them all in again !
Other than that, it tends to upgrade fine.
Cheers, Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Gary T. Benner
> Sent: Monday, July 12, 1999 7:19 PM
> To: Multiple recipients of list offtopic
> Subject: [DUG-OFFTOPIC]: MSSQL 4.2 --> MSSQL 7
>
>
> Hi all,
>
> I'm doing a review of a Delphi 1 app purpose written by someone
> else for a client, where they used MSSQL 4.2. It
> needs to be made Y2K compliant.
>
> The budget will only allow for an upgrade to MSSQL 7 rather than
> the desired upgrade to Interbase. (Due to the large
> number of queries, stored procedures and trigger in MSSQLsyntax)
>
> Has anyone had experience in taking MSSQL version 4.2 metadata up
> to version 7, or 6.5?
>
> Any gotchas?
>
> Any hair left?
>
> TIA
>
> Gary
>
> PS: New app will be coded in Delphi 4 of course.
>
>
> ========================================================
>
> Gary Benner - Software Developer [EMAIL PROTECTED]
> Corporate Software New Zealand Limited Auckland - New Zealand
> tel: +64-9 846-6067 (24hr) fax: +64-9 846-6152 mob: (021)-966-992
> Software System Design - Consulting - Mentoring - Data Modelling
> Client Server - Delphi - Interbase - Oracle - Web-based Technologies
> Electronic Automation and Systems - Microcontroller Design & Software
> http://www.corporate.co.nz
>
> Ref#: 41006
>
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
