4.2 did not support declarative referential integrity so it was all done with triggers.
It might be worth importing the table definitions into a data modelling tool, tarting
up the RI and then getting it to write your create table statements.
-----Original Message-----
From: Gary T. Benner [SMTP:[EMAIL PROTECTED]]
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
application/ms-tnef
