Re: Table and Field Name Capitalization

In my experience, I have been trying several times in integrate different databases as Oracle an SQL Server or DB2 in AS/400 via database tools. The results have been always tedious and unsuccessful. You have in the market several tools to do these kind of operations, the worst of these tools are the prices, but you should evaluate it.

With ETL or EAI tools you can capitalize and concatenate several fields with a mouse click.

Sorry,

Aurelio

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> escribió en el mensaje news:E2F6A70FE45242488C865C3BC1245DA70388191D_at_lnewton.leeds.lfs.co.uk...
> Morning,
>
> I believe, although I'm not 100% sure, that the capitalisation of object
> names within the database is actaully an ANSI standard. I work with
> Oracle and Interbase/Firebird (to a lesser degree) and
> Interbase/Firebird was recently updated to comply with an ANSI standard
> which states (roughly) that any object name passed in double quotes must
> be processed without being upper cased. Anything not in double quotes
> should be upper cased internally. If SQLServer doesn't work to this
> standard, then I'm afraid it's SQLServer that is the 'wrong' system
> here.
>
> Not much help I'm afraid :o(
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Thu Apr 10 2003 - 09:44:21 CDT