ph back end move oracle to sqlserver
Robert Edis
robeconsult@sbcglobal.net
Tue, 3 Aug 2004 13:16:31 -0700 (PDT)
--0-859118745-1091564191=:25655
Content-Type: text/plain; charset=us-ascii
This depends on how much embeded SQL there is in the PH code. I don't even think you need to recompile if the PH code remains on the same box and only the RDBMS is being changed. If the PHD is pointed to the new RDBMS and not changed otherwise then no code needs to be recompiled.
There are significant syntax differences between PL/SQL and T-SQL. E.g.
- The latter is closer to ANSI standard and doesn't have nifty features like the DECODE() function in Oracle.
- Cursors in SQL Server are very inefficient so be careful in transferring any from the Oracle RDBMS.
- The is no sequence table in SQL Server.
Good luck,
Blue
shulbert@littlejohnfrazer.com wrote:
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
" 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.
--0-859118745-1091564191=:25655
Content-Type: text/html; charset=us-ascii
<DIV>This depends on how much embeded SQL there is in the PH code. I don't even think you need to recompile if the PH code remains on the same box and only the RDBMS is being changed. If the PHD is pointed to the new RDBMS and not changed otherwise then no code needs to be recompiled.</DIV>
<DIV> </DIV>
<DIV>There are significant syntax differences between PL/SQL and T-SQL. E.g.</DIV>
<DIV>- The latter is closer to ANSI standard and doesn't have nifty features like the DECODE() function in Oracle. </DIV>
<DIV>- Cursors in SQL Server are very inefficient so be careful in transferring any from the Oracle RDBMS.</DIV>
<DIV>- The is no sequence table in SQL Server.</DIV>
<DIV> </DIV>
<DIV>Good luck,</DIV>
<DIV> </DIV>
<DIV>Blue</DIV>
<DIV><BR><BR><B><I>shulbert@littlejohnfrazer.com</I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>does anyone have experience of moving their back-end from oracle to ms sqlserver?<BR><BR>on the powerhouse side, is it simply a question of pointing the dictionary at the new database and recompiling?<BR><BR>thanks and regards,<BR>stephen.<BR><BR>--<BR><BR>Littlejohn Frazer<BR>Chartered Accountants<BR>1 Park Place<BR>Canary Wharf<BR>London<BR>E14 4HJ<BR><BR>Tel: 020 7987 5030<BR>Fax: 020 7987 9707<BR>Web: www.littlejohnfrazer.com<BR><BR><BR>The information contained in this communication is confidential and may<BR>be legally privileged. It is intended solely for the use of the<BR>individual or entity to whom it is addressed and others authorised to<BR>receive it. If you are not the intended recipient you are hereby<BR>notified that any disclosure, copying, distribution or taking of any<BR>action in reliance on the contents of this information is strictly<BR>prohibited and may be
unlawful.<BR><BR>Littlejohn Frazer reserves the right to monitor the content of any<BR>message sent to or from littlejohnfrazer.com and its associate domains,<BR>fmi-litjon.co.uk and litjon.co.uk<BR><BR>A list of partners may be inspected at the above address which is<BR>also the address for serving documents.<BR><BR>Registered to carry on audit work by the Institute of Chartered<BR>Accountants in England & Wales, and authorised and regulated by the<BR>Financial Services Authority for investment business.<BR><BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe <PASSWORD>" in message body to powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This list is closed, thus to post to the list you must be a subscriber.<BR></BLOCKQUOTE>
--0-859118745-1091564191=:25655--