ph back end move oracle to SQLserver

[Joe Boyle]

Hi Stephen,

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.

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
shulbert@littlejohnfrazer.com
Sent: 03 August 2004 10:27
To: powerh-l@lists.sowder.com
Subject: ph back end move oracle to sqlserver


does anyone have experience of moving their back-end from oracle to ms
sqlserver?

on the powerhouse side, is it simply a question of pointing the dictionary
at the new database and recompiling?

thanks and regards,
stephen.

--

Littlejohn Frazer
Chartered Accountants
1 Park Place
Canary Wharf
London
E14 4HJ

Tel: 020 7987 5030
Fax: 020 7987 9707
Web: www.littlejohnfrazer.com


The information contained in this communication is confidential and may
be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it.  If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking of any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful.

Littlejohn Frazer reserves the right to monitor the content of any
message sent to or from littlejohnfrazer.com and its associate domains,
fmi-litjon.co.uk and litjon.co.uk

A list of partners may be inspected at the above address which is
also the address for serving documents.

Registered to carry on audit work by the Institute of Chartered
Accountants in England & Wales, and authorised and regulated by the
Financial Services Authority for investment business.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.