Subject | Re: [ib-support] Migrating IB 6.02 to FB 1.5 |
---|---|
Author | Tim Ledgerwood |
Post date | 2003-06-12T14:35Z |
OK - I have rewritten all SPs and SQL so that there are explicit JOINs and
so that all queries are unambiguous, so that should be OK.
Since our engineers support 900 sites countrywide, and us IB Console for
admin etc., I am a bit more worried about that than the actual SQL or code
I am using.
I have also started changing the IBX stuff I use to IBO.
At 04:16 PM 6/12/2003 +0200, you wrote:
so that all queries are unambiguous, so that should be OK.
Since our engineers support 900 sites countrywide, and us IB Console for
admin etc., I am a bit more worried about that than the actual SQL or code
I am using.
I have also started changing the IBX stuff I use to IBO.
At 04:16 PM 6/12/2003 +0200, you wrote:
>The most important difference is that Firebird doesn't accept ambiguous[Non-text portions of this message have been removed]
>queries, so you have to qualify all fields that exist in more than one
>table that is part of the select.
>
>I guess there may also be a few new reserved words, the ones I can think of
>straight away is FIRST and SKIP.
>
>Though mostly I think it should be a pretty straight forward migration.
>
>Set
>
>At 15:00 12.06.2003 +0200, you wrote:
> >OK - I have a gap in my work, and am now ready to take the plunge. Am
> >running IB 6.02 on WIN 2000 pro.
> >
> >Are there any issues in the migration that I should be aware of? Tips,
> >tricks,. hints?
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/2003