How to work different table and field names

[cointec]

Hello, I'm in process of migrating one database from Firebird to Oracle in order to work with the two engines from my application.
Firebird has a limit of 31 char for tables and field names, and Oracle has a limit of 30 char for the same.

I have some tables and some fields in firebird of 31 char, and in the migration process to Oracle I'm truncating them.

How is the best way to work with tables/fields from UniDac?

[cointec]

No comments?
Is not posible through macros?

[AlexP]

Hello,

Please describe in more details the behavior you want to implement - and we will try to help you resolve the issue.

[cointec]

I have a table in a firebird database whose length is 31 characters. For Example

TABLE_XXXXXXXXXXXXXXXXXXXXXXXXY

I have migrated the table to Oracle, but Oracle only admit 30 char for objects. Then the migrated table in Oracle is
TABLE_XXXXXXXXXXXXXXXXXXXXXXXX

I have a form that select, insert, Update and delete from that table. With UniQuery, I want to know if there is one option, that depending on the engine, I can change the part from SQL, SQLInsert, ... where appears the table name via macros.

It also happen with some table fields that are 31 char long.

Thank you.

[AlexP]

If you want to use both databases simultaneously without modifying queries, you can use macros
https://www.devart.com/unidac/docs/?unisql.htm .