RE Oracle to SQLserver

[Joe Boyle]

If you or your team have been on the two 'Powerhouse relational Interface'
courses, then I suggest you get your two course manuals out and have a
re-read ASAP. Otherwise, I recommend that you get yourself and colleagues
booked in at Manchester.

There are quite a number of differences, particularly at the procedural
level; where often additional designer transactions are required, and all to
achieve quite ordinary designer level processing.

As for sequence processing, with SQLserver, the sequence is an attribute of
the column, I do not recall a sequence table like object as with Oracle.

Also page level locking can be an issue, so I expect you will need a
SQLserver DBA on hand to design in appropriate 'granularity' when it comes
to row level locking.


Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this 
e-mail and any attachments sent with it may have been altered without the
consent or knowledge of the author.